Re: Need INSERT help

[Grigore Dolghin]

Hi

If you're connecting using SQLStringConnect() then I guess you are executing the SQL commands using SQLExec(). This function returns a numerical value (-1 if any error has occured). To find out what happened on the server you need to call AError(), which creates an array that contains the error info returned from server. A code skeleton would look like that:

lnResult = SQLExec(lnConnectionHande, "SQL INSERT CODE HERE")
If lnResult < 0
AError(laError)
Messagebox("An error has occured. Error message is: " + Chr(13) + ;
laError[1,2],48,"SQL Error")
EndIf