Re: Update and insert in one sql statement in access error




>iam use delphi7.0 and ADOQuery.
>when make update and insert in one statement show error syntex
>error(missing operator)
Access does not support more than one SQL statement in a query
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.



Relevant Pages

  • RE: ORA-03113 Error from DBI
    ... ORA-3113 quite often means call Oracle support. ... typically that tells of the error occuring and gives the name of a trace file. ... SQL statement that was executing usually at the time of the crash. ... To: Hawkes, Richard ...
    (perl.dbi.users)
  • Re: adoQuery - unspecified error on open
    ... But found that when I took my new ADOQuery ... I had to delete the whole SQL statement, close the editing window, reopen ... >> get the parameters yesterday but have since broken them as well. ... If I try to use a parameter, even in design it is not ...
    (borland.public.delphi.database.ado)
  • RE: FK Constraint Raised for no reason I can find?
    ... the constraints won't be copied to the destination database. ... But you could modify the sql statement for creating the table in the ... SQL Statement window above. ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • RE: FK Constraint Raised for no reason I can find?
    ... the constraints won't be copied to the destination database. ... But you could modify the sql statement for creating the table in the ... SQL Statement window above. ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • Strange behaviour with and : simbols in Ado
    ... I have very strange problem with SQL statement below while trying to execute ... it in ADOQuery ... INSERT INTO Questions (SurveyID, questionnr, required, answertype,, ... I thing this is ADO parameter parser error. ...
    (borland.public.delphi.database.ado)