Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQLPreview

Status
Not open for further replies.
DataTact

DataTact

Programmer
Aug 17, 2007
1
US
I'm trying to troubleshoot a datastore problem that always returns a -1 when I issue li_Retcode = ds_1.update().

I put a breakpoint in the SQLPreview event and captured the value of SqlSyntax. Next, I executed that SQL statement in the database painter, it worked just fine.

What can possibly be wrong with the datastore?


 
Sort by date Sort by votes
First hardcode the sql with the variable values in the datastore and run and see if it works. It could be a problem with the arguements being passed to it.
 
Upvote 0 Downvote
When you get the -1 return code from the update, what is the message text in the SQLCA object?

Matt

"Nature forges everything on the anvil of time
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top