Search results for query: *

Would someone have any ideas on the above problem. Thx.

Hi...I need to retrieve a value from a FoxPro database using a SQL statement and put that value into a variable. When I try to Select QOH and run lQOH = conn.Execute sqlstatement, recordsaffected, adCmdText I get a compile error, expected '='. Could someone please help me out. Thanks..John...

Hi: The above email still does not work. If I put a invalid barcode number in, no error is returned and always goes to CommitTrans. Any other ideas? Thanks...John

How do you retreive success and failures from the SQL code below, and in the second SQL how would I get the QOH value from the SQL. Thanks again for your help Set conn = New ADODB.Connection Let conn.ConnectionString = "Driver={Microsoft Visual Foxpro...

Thanks....Now how do you do error handeling when using conn.execute("sql statement") in vb accessing vfp 6. If this statement fails how do you know? If you do retval = conn.execute ("sql statement") you get an error, if you try capturing err or error this dosen't work. Help...

I still can not write the transaction to the database unless I leave the function. I'm using Visual Fox Pro as my database. Does anyone have any other ideas? Thanks

Thanks for everyones input...tereschisty idea worked however the record does not commit until I leave the function, even with a begintrans, and commitTrans. Is there another way to commit the transaction within the function?

When I use the update command in the following code I get a Run Time Error......Statement too long. Could you tell me how to use the update command in this case. It's VB6 and Visual FoxPro 6. Thanks Private Sub Command2_Click() Set conn = New ADODB.Connection Let conn.ConnectionString =...

Hi..The above worked, but when I do a rs1.update I get a run time error.......Statement too long. What do I need to do for an update command?

The following code returns -1 in the text box when I do a recordcound, and other errors when I try to update. I'm trying to connect a FoxPro table. Can someone tell me what I have done wrong, and how to correct the problem Private Sub Command1_Click() Set conn = New ADODB.Connection Let...