with QryAlter do
       begin
         SQL.Clear;
         SQL.Text := 'UPDATE ADesloc SET  CodData = ' +
DMPM.TblAtend.FieldByName('CodData').AsString +
           ' where BopN = ' + QryNumBop.FieldByname('BopN').AsString;
         ExecSQL;

How to solve the problem with this query?
below the error:
---------------------------
Bopmes
---------------------------
DBISAM Engine Error # 11949 SQL parsing error - Expected NULL, Date, or
Timestamp expression but instead found / in UPDATE SQL statement at line 1,
column 36.
---------------------------
OK
---------------------------
EG®

E®Eletronic


As a guess it will be the date format you've used. Dates for the newer versions of DBISAM have to be in ANSI format ie YYYY-MM-DD

Roy Lambert [Team Elevate]

Ok Roy, I'm using version 4.17 and utlize this function to convert the date,
but still get an error. compiles normally only happens when you run the
query.
---
function DateToSql(Data: TDateTime): String;
begin
Result := QuotedStr(FormatDateTime('YYYY-MM-DD', Data));
end;
-----
SQL.Clear;
         SQL.Text := 'UPDATE ADesloc SET  CodData = ' +
DateToSql(DMPM.TblAtend.FieldByName('CodData').AsDateTime) +
           ' where BopN = ' + QryNumBop.FieldByname('BopN').AsString;
         ExecSQL;  ''''
---------------------------
Debugger Exception Notification
---------------------------
Project BOPMES.exe raised exception class EDBISAMEngineError with message
'DBISAM Engine Error # 11949 SQL parsing error - Expected NULL, Memo
expression but instead found / in UPDATE SQL statement at line 1, column
61'. Process stopped. Use Step or Run to continue.
---------------------------
OK   Help
---------------------------
"Roy Lambert" <roy.lambert@skynet.co.uk> escreveu na mensagem
news:1B15AF1A-5F83-4DED-B9B0-B60FD827533C@news.elevatesoft.com...
> E®Eletronic
>
>
> As a guess it will be the date format you've used. Dates for the newer
> versions of DBISAM have to be in ANSI format ie YYYY-MM-DD
>
> Roy Lambert [Team Elevate]
>

E®Eletronic


The error position has moved from 36 to 61 so a wild guess would be BopN is a date field and QryNumBop.FieldByname('BopN').AsString also needs to be in the right format.

Roy Lambert [Team Elevate]

Roy, Thanks, the problem was occurring in the second field. resolved.
EG®

"Roy Lambert" <roy.lambert@skynet.co.uk> escreveu na mensagem
news:B2188833-CE19-4128-9857-E9A9A52139A1@news.elevatesoft.com...
> E®Eletronic
>
>
> The error position has moved from 36 to 61 so a wild guess would be BopN
> is a date field and QryNumBop.FieldByname('BopN').AsString also needs to
> be in the right format.
>
> Roy Lambert [Team Elevate]
>

<< Ok Roy, I'm using version 4.17 and utlize this function to convert the
date, but still get an error. compiles normally only happens when you run
the query. >>

Just so you know, you can use these TDBISAMEngine methods to convert
dates/times to the proper format:

http://www.elevatesoft.com/manual?action=mancompmethod&id=dbisam4&product=d&version=7&comp=TDBISAMEngine&method=DateToAnsiStr

http://www.elevatesoft.com/manual?action=mancompmethod&id=dbisam4&product=d&version=7&comp=TDBISAMEngine&method=DateTimeToAnsiStr

http://www.elevatesoft.com/manual?action=mancompmethod&id=dbisam4&product=d&version=7&comp=TDBISAMEngine&method=TimeToAnsiStr

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim, the DBISam is an excellent tool.
EG®
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> escreveu na
mensagem news:0CD27FE5-671E-4578-AAE8-08A6DA6C41BD@news.elevatesoft.com...
>
> << Ok Roy, I'm using version 4.17 and utlize this function to convert the
> date, but still get an error. compiles normally only happens when you run
> the query. >>
>
> Just so you know, you can use these TDBISAMEngine methods to convert
> dates/times to the proper format:
>
> http://www.elevatesoft.com/manual?action=mancompmethod&id=dbisam4&product=d&version=7&comp=TDBISAMEngine&method=DateToAnsiStr
>
> http://www.elevatesoft.com/manual?action=mancompmethod&id=dbisam4&product=d&version=7&comp=TDBISAMEngine&method=DateTimeToAnsiStr
>
> http://www.elevatesoft.com/manual?action=mancompmethod&id=dbisam4&product=d&version=7&comp=TDBISAMEngine&method=TimeToAnsiStr
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>