Type: Posts; User: morbid.ivan
Search took 0.02 seconds.
For example my textbox(0) only allows 12 varchar after reaches the maximum characters allowed, all the remaining characters
will be automatically moved to textbox(1) and so on....
and also this:
date(IfNull(Null,'" & Format(txtDates(1).Text, "yyyy-MM-dd") & "'))
Thank you for viewing... I solve it.
Dim sDateEnd As String
If IsDate(txtDates(1).Text) Then
sDateEnd = Format(txtDates(1).Text, "yyyy-MM-dd")
sDateEnd = "NULL"
I am using Vb6 and Mysql database
I am having a problem on saving null value on date field.
If it has a date it saves, and if doesn't have it also saves but when
I tried to look at the...
strQuery = "SELECT LAST_INSERT_ID() as retID FROM employee"
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open strQuery, conn, adOpenForwardOnly, adLockOptimistic
How to I get the ID after I insert record?
I want it to display the return ID number on Textbox...
This is how I insert record:
Insert Single Only
Dim strQry As String
+Root (I got this part)
--Parent (I got this part)
---Child (Error starts here)
I am trying to join 2 tables, but no success.
I got this Error "Invalid object 35610"
I have 2 different tables table1 name 'tab1' and table2 named 'tab2'.
I can insert record to table2 and update table1 using separate button. 1 button for adding/insert and 1 for updating table1
In mysql, query worked well.
UPDATE `tab1` SET `Addr`='SPL',`Remarks`='NEW HOME' WHERE `LinkID`='E-001';INSERT INTO `tab2` (`LinkID`,`Addr`,`Remarks`) VALUES ('E-001','SPL', 'NEW HOME');
I insert record on table2 named 'tab2'
LinkID = 'E-001'
Address = txtaddr.Text
Remarks = txtRemarks.Text
At the same time it must update table1 name...
Is it possible to join 2 different statement in one query?
I use this to insert record
Dim strQry As String
strQry = "INSERT INTO tab2 " & _
"(LinkID, Addr, Remarks) " & _
I have a blank Listview, and I also have a List Box (Checkbox)
Listbox Items: (database Table Fields)
I get it... Problem solved
If Not node.Parent Is Nothing Then
If Not node.Parent.Parent Is Nothing Then
Dim rs As ADODB.Recordset
Dim lItems As ListItem
ListView1.View = lvwReport
Set rs = New ADODB.Recordset
.CursorLocation = adUseClient
Please check out what went wrong.
Dim objNode As node
Set objNode = .SelectedItem
If Not objNode Is Nothing Then
If objNode.Children > 0 Then
Selecting treeview nodes
>--- IBANEZ (Parent Node)
|------ Gio (Child Node)
SELECT a.ID, a.Name, b.ID, b.Name, b.Relationship FROM tbl_Name AS a
INNER JOIN tbl_Dependents AS b ON b.ID=a.ID
1 |James Hinrich
2 |Larch Hamster
Is there anyone has cr90dbexwin_en.zip?
I can't download it from: ftp://ftp.crystaldecisions.com/outgoing/ehf/cr90dbexwin_en.zip
How do I Import more than 1GB database?
Is it possible to do this with work bench?
Is it possible on Lost Focus if no value, clear format or simply blank?
Example : Mask Format "##/##/####"
With Value : "01/01/2015"
Without Value : "//"
How do I remove this "//" if no date...
As I type I need to have a slash char on count of 2 and 5 which is already done.
Now, my problem is when I press backspace I was stuck on this...
Is it possible password will based on date?
can you please show some examples? im not knowledgable about AES Encryption
is it possible to have a random login password each day based on date and time?
for security reasons.
How to generate date range quarterly.
option 1 - 1st quarter
option 2 - 2nd quarter
option 3 - 3rd quarter
option 4 - 4rt quarter
I choose "option 4"
Public Sub heightLister(cbo As ComboBox)
Dim iWeight As Integer
Dim iCtr As Integer
Dim iLoop As Integer
For iLoop = 4 To 6
How do I sort this out?
is it possible to have a custom autoincrement number that resets every year?
Reference : Adodb
Database : MySql
How to get the auto increment number after adding new record?
Thanks in advance
I solve the problem guys, by re-installing wamp server and finally database shown up.
I am having a problem on WAMP Server (PHPmyAdmin) when I open it, no database on list but still accessible.
When I try to create new database I am getting error "Unknown database" but in ODBC test...
- > Current child-form State (Maximized) let's call this "Form #1",
trying to open another form which is in (Normal) state,
the "Form #1" resizes into "Normal State" and it should not...
How to avoid form resizing when opening another form?
Take a look at this :
Dim rpt_Sql As String
rpt_Sql = "SELECT * From SQL_MAIN " _
& "INNER JOIN SQL_RELATE ON SQL_MAIN.BATCH = SQL_RELATE.BATCH " _
& "Where SQL_MAIN.BATCH='1'"
Thank you... I will wait for your respond.
Result I got :
Query still giving me same message. Cannot found
INNER JOIN SQL_RELATE ON SQL_MAIN.BATCH = SQL_RELATE.BATCH
WHERE SQL_MAIN.BATCH =1
LIMIT 0 , 30
I generated this from MySql, but when I put this on VB6 same error...
Nope, I don't know how.
Can please tell me how to do it?
[QUOTE=digitalShaman;4753955]where does the error pop up? is it in this line:
rs_Report.Open rpt_Sql, conn
? then it has got nothing to do with crystal reports.
The report opens based on query...
Click Here to Expand Forum to Full Width
Survey posted by VBForums.