Type: Posts; User: morbid.ivan
Search took 0.02 seconds.
+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...
Public Function konektodata(strServer As String, uName As String, uPass) As Boolean
On Error GoTo errHandle
MyOdbcOption = optFoundRows + optVB + optBigPacket +...
The table exist. Check this out...
I am having a problem Joining 2 tables in crystal report 9.
Always showing : Remove Table
The database table "sql_relate" cannot be found.
Dim rs_Report As ADODB.Recordset
(Text Type) Primary field
Dim rsGEN As ADODB.Recordset
Dim sqlCriteria As String
Dim cNum As Long
Set rsGEN = New ADODB.Recordset
rsGEN.CursorLocation = adUseClient
rsGEN.CursorType = adOpenStatic
Is my approach is right, having a Front-end every user?
Click Here to Expand Forum to Full Width