You are not logged in.
Pages: 1
Who share Any examples about this? thx
Does the version 1.1.8 still update or stop when Revision 2.x of the framework starts ?
@ab,thanks a lot.
error --compiled by Delphi 2010
Checking project dependencies...
Building TestSQLite3Pages.dproj (Debug configuration)
[DCC Fatal Error] SynCommons.pas(52105): F2084 Internal Error: C1872
Failed
Elapsed time: 00:00:00.2
thanks ,ab
Ver 7858-7859 :
[dcc64 Error] SynCommons.pas(53861): E2004 Identifier redeclared: 'esc'
[dcc64 Error] SynCommons.pas(53900): E2004 Identifier redeclared: 'esc'
[dcc64 Fatal Error] frmServer.pas(8): F2063 Could not compile used unit 'SynCommons.pas'
Failed
AB ,PLS
Should have been fixed now by https://synopse.info/fossil/info/1f1e0c8881
Sorry for the inconvenience.
For you ab, I am eternally grateful.
Statics.dpr
[dcc64 Error] SynCommons.pas(22989): E2003 Undeclared identifier: 'SwapEndian'
[dcc64 Fatal Error] Unit1.pas(9): F2063 Could not compile used unit 'SynCommons.pas'
Failed
Elapsed time: 00:00:02.1
the latest version is ok! thx ab.
'127.0.0.1' -----port?
Please check https://synopse.info/fossil/info/a05ff8978d
thank you very much!
No error before 5797 & 5798.
5797 & 5798 version error when compile。
[dcc64 Error] SynVirtualDataSet.pas(194): E2003 Undeclared identifier: 'TSQLDBFieldType'
[dcc64 Error] SynVirtualDataSet.pas(211): E2005 'TSQLDBFieldType' is not a type identifier
[dcc64 Error] SynVirtualDataSet.pas(273): E2005 'TSQLDBFieldType' is not a type identifier
[dcc64 Error] SynVirtualDataSet.pas(742): E2003 Undeclared identifier: 'TJSONWriter'
[dcc64 Error] SynVirtualDataSet.pas(752): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(755): E2008 Incompatible types
[dcc64 Error] SynVirtualDataSet.pas(755): E2125 EXCEPT or FINALLY expected
[dcc64 Error] SynVirtualDataSet.pas(756): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(756): E2029 ')' expected but identifier 'ColNames' found
[dcc64 Error] SynVirtualDataSet.pas(761): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(762): E2081 Assignment to FOR-Loop variable 'f'
[dcc64 Error] SynVirtualDataSet.pas(763): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(763): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(763): E2029 'END' expected but ')' found
[dcc64 Error] SynVirtualDataSet.pas(764): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(766): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(769): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(771): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(773): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(775): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(777): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(781): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(782): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(783): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(786): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(787): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(789): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(792): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(793): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(794): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(797): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(802): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(809): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(810): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(811): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(816): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(818): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(820): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(822): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(824): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(826): E2066 Missing operator or semicolon
[dcc64 Error] SynVirtualDataSet.pas(827): E2029 'UNTIL' expected but 'END' found
[dcc64 Error] SynVirtualDataSet.pas(828): E2029 Declaration expected but identifier 'W' found
[dcc64 Error] SynVirtualDataSet.pas(837): E2029 '.' expected but ';' found
[dcc64 Warning] SynVirtualDataSet.pas(838): W1011 Text after final 'END.' - ignored by compiler
[dcc64 Error] SynVirtualDataSet.pas(199): E2065 Unsatisfied forward or external declaration: 'TDocVariantArrayDataSet.InternalInitFieldDefs'
[dcc64 Error] SynVirtualDataSet.pas(200): E2065 Unsatisfied forward or external declaration: 'TDocVariantArrayDataSet.GetRecordCount'
[dcc64 Error] SynVirtualDataSet.pas(201): E2065 Unsatisfied forward or external declaration: 'TDocVariantArrayDataSet.GetRowFieldData'
[dcc64 Error] SynVirtualDataSet.pas(203): E2065 Unsatisfied forward or external declaration: 'TDocVariantArrayDataSet.SearchForField'
[dcc64 Error] SynVirtualDataSet.pas(210): E2065 Unsatisfied forward or external declaration: 'TDocVariantArrayDataSet.Create'
[dcc64 Error] SynVirtualDataSet.pas(273): E2065 Unsatisfied forward or external declaration: 'ToDataSet'
[dcc64 Fatal Error] SynDBVCL.pas(674): F2063 Could not compile used unit 'SynVirtualDataSet.pas'
Failed
Elapsed time: 00:00:02.1
from last mORMot version now,all questions sloved. I haven't change any code.
thanks a lot AB.
Are you sure that "'select * from DB_CZC where yyzh = ?" does not return too much information?
There is no paging/cursor in our classes: all data is retrieved from the server and converted into JSON.
yes,I'm sure that returns 1 record。
in 32-bit server and 32-bit or 64-bit client,it's ok.
Looks like you have a x32 SQL server? If yes - try to install x64 version of SQLNCLI11 (can't found a download link on Microsoft)
the latest version of SQLNCLI11-->MICROSOFT SQL SERVER 2012 NATIVE CLIENT:
https://www.microsoft.com/en-US/downloa … x?id=50402
So the SynDBRemote communication is fixed.
But there is still a problem with your 64-bit OleDB SQLNCLI11 provider...
I will try.
Thank you AB very much.
Did you try with the https://synopse.info/fossil/info/512f51580e fix ?
thanks a lot,AB
server 32-bit,client 32-bit---->ok
server 32-bit,client 64-bit---->ok
server 64-bit,client 32-bit or client 64-bit---->sceond err.
Looks like you have a x32 SQL server? If yes - try to install x64 version of SQLNCLI11 (can't found a download link on Microsoft)
SQL server 2012 X64
I guess that your client and your server does not have the very same archi: one is 32-bit, the other 64-bit.
Try to comment the VFill: cardinal; field in TSQLDBParam record definition.
See https://synopse.info/fossil/info/512f51580eBTW are you using TOleDBMSSQL2012ConnectionProperties?
server 32-bit,client 32-bit---->ok
server 32-bit,client 64-bit---->first err.
server 64-bit,client 32-bit or client 64-bit---->sceond err.
I 'm using TOleDBMSSQL2012ConnectionProperties in server.
Thank you AB very much.
As a newbie,I'm studying mORMot,I meet a curious question, you know, maybe it is very general.
I wrote a server code and a client code,
the same code,32-bit compiled ,does work。
but 64-bit compiled,error occurs.
code here:
updatecount := Props.ExecuteNoResult(SqlS, [qymcD, cphD, cxD, yyzhD]);
error info:
TSQLDBWinHTTPConnectionProperties.Process(cExecute):server raised ESQLDBRemote with 'Invalid VType=0 parameter #2 in TOleDBConnection.Process(cExecute)'
code here:
I := Props.Execute('select * from DB_CZC where yyzh = ?',[yyzhD], @R);
error info:
TSQLDBWinHTTPConnectionProperties.Process(cExecuteToBinary):server raised EOleDBException with 'TOleDBConnection:存储空间不足,无法完成此操作。'
存储空间不足,无法完成此操作(=Not enough storage to complete this operation)。
Any advice will be much appreciated.
Thank you ab for your great work.
Pages: 1