Zeoslib Portal

Hello Mohammed, for your usecase may be it is the best to connect to the local DB as a default. Then you check your remote database in a separate thread and if everything works out good you might want to change to the remote database. For checking, if the remote database is available I use this thre...

Hello mparak, I have a program where the user decides if he wants to use the online database or offline database. When the user decides for the offline database, I start a separate thread that has its own TZConnection to try to connect to the online database and give a message to the user if it is a...

Hello Andreas, in your case I suggest to just use regular Strings in your Delphi application. Zeos will do all the necessary conversions for you. Just set ClientCodePage := 850; Also, depending on your RDBMS, you could ask the RDBMS to do the necessary conversions by asking the RDBMS to deliver all ...

Hello misko2k,

for this you would need two connections (TZConnection) with the current Zeos components. Each one has its own transaction. So you have one connection for the user and one connection for the timer.
Each connection will have its own queries and so on...
Best regards,

Jan

Hello delphichem, hello Michael, Soo - I did some test and for me everything works as expected. This is my testcase: procedure TForm1.Button1Click(Sender: TObject); begin Connection.Connect; try Connection.StartTransaction; try sleep(1000); Query.SQL.Text := 'insert into Sicherungspfad (BENUTZER, PF...

Hello Michael, hello delphichem, IMHO that's expected if AutoCommit = True. Can't see there is something wrong. I am not sure, wether Michael is right. With AutoCommit = True I would expect StartTransaction to start a new explicit transaction that I have to finish with Commit or Rollback explicitly....

Hello sfxcc, maybe it helps to use the date literal 'TODAY'? See http://www.firebirdsql.org/en/firebird-date-literals/ So your query would look like this: UPDATE MYTABLE SET ENDDATE='TODAY' WHERE MYID=1 What you say about altering the value of columns multiple times to get them right seems odd to me?

Hello EgonHugeist, I am not sure, what to think because I simply don't have enough Knowledge... You pointed me to TField.Size. The delphi help says the same for Fields of ftString in Delphi 6 and Delphi XE2: ftString: Size is the maximum number of characters in the string. (see http://docwiki.embarc...

Hello EgonHugeist and luizcesarap, I really would like to have a good opinion about this problem. But may I first ask some questions, where I can only make guesses right now? For the FieldSize: @luizcesarap: Your database has a default encoding of ISO8859_1. Is that also the character set, that you ...

Hello BytePlayer, please have a look at the attached components. This is the data pump described earlier and an SQL-Dump generator. Both have limitations. Until now I only use them with Zeos 6.6.6 and Delphi. So if you use newer Delphi versions, especially unicode eneabled ones, or Zeos 7 your milea...

Hello BytePlayer, a component for creating sql scripts for inserting - that is something on my todo list. What I can give you is a data pump component. This component is in a state, where I can say, it works for me and some of my customers. If you want to, I can publish it here and write some kind o...

Hello BytePlayer and EgonHugeist, Maybe this thread helps about TZConnectionGroup and TZGroupedConnection: http://zeos.firmos.at/viewtopic.php?t=2760 Byteplayer, if I understand that thread correctly, these components will not help you. The special case in your first post seems to be the normal use ...

Hello andreventu, as far as I know there is no possibility to solve this because the connection to the database is always done by the database client libraries. It seems like you have three options: - use some third party application that allows database connections through proxies for your special ...

Hello Michael, the ZEOS_VERSION from ZClasses is a start. Now I can check if the value there is in a list of values (6.6.6-stable, 6.6.5-stable, 6.6.4-stable, ...). But for the future I propose to add a second constant in ZClasses.pas like const ZEOS_VERSION_NUM = 700 or something like that. This wo...

Hello Michael, originally I was more thinking along the lines of something like const ZEOS_VERSION = 700; but then one cannot check wether this is declared at all and so a code like {$IF ZEOS_VERSION < 700} will break when an older ZEOS is used. whereas with your proposal of {$DEFINE ZEOS_VERSION = ...