Zeoslib Portal

Hello Baldur2630,

could you please share the solution of your problem with us?
Best regards,

Jan

Hello jjeffman,

could you post your code for saving and also for displaying the data in the database?
Best regards,

Jan

Hello jjeffman,

normally I expect the Zeos 6 SQLite driver to do the encoding for you. Normally there should be no need for you to do a UTF8Encode. Did you try to use SQLite without UTF8Enceode, just as with every other regular database?
Best regards,

Jan

Hello Baldur2630, just use an SQL query for the first one. Ie: var MyCount: Integer; begin ... Query.Close Query.SQL.Text := 'SELECT COUNT(DISTINCT types.typeid) as COUNTX FROM types'; Query.Open try MyCount := Query.FieldByName('COUNTX').AsInteger; finally Query.Close end; ... end; and for the Seco...

Hello alexcagliari, if you want to insert the data directly into the SQL then you need to encase the Strings in quotes: // inizia sql with ZQuery1 do begin Active:=False; SQL.Clear; SQL.Add('Insert into logbook(Callsign,Name,City) values(' + QuotedStr(Callsign.Text) + ',' + QuotedStr(Nome.Text) + ',...

Hello Mamenhi, I am not sure how you plan to secure you data against people who want to read it. But nonetheless normally things should be like this: Install MariaDB on your internet host Open a port for communication in the firewall of the internet host set the hostname in TZConnection to that of y...

Hello kidjake28,

how do you put the pictures into the database and what kind of pictures are in it (jpeg, png, ...)?
If you say, it works for "sivak3 sqlite3 dbase vcl tools" then this seems to mean that it works for DBase which is a whole different story to SQLite?
Best regards,

Jan

Hello contecavour65,

which version of Delphi do you use? Do you use the packages to install Zeos? If so - in which package does the error happen?
Best regards,

Jan

Hello Chunkiebone, there are several ways to accomplish what you want. But the most easy way might be to use a stored procedure in Firebird that acts after insertion of a record to the payments table. For safeguarding the data you also might want to find a way to keep people from messing with the ba...

Hello chunkiebone, I am not sure what you want to do but keeping the same data twice in the database is good way to get inconsistent data if you make a mistake. For querying two or more tables use the join synax. Assuming you have three tables: masterlist (id, client, address) daily_payments (date, ...

hmmm - something like that: procedure copyfields(Src, Target: TDataSet; Blacklist: String); var x: Integer; begin Blacklist := ';' + Blacklist + ';'; for x := 0 to Src.Fields.Count do begin // iterate over all source fields if Pos(';' + Src.Fields[x].FieldName + ';', Blacklist) <> 0 then begin //che...

Hello Baldur2630,

if you don't close the connection explicitly it will close down itself when it gets destroyed by the destruction of the form, I guess. I prefer to close it down myself.
Best regards,

Jan

Hello chunkiebone, Densetsu7,

Densetsu7s idea is corect except that with Firebird one never needs to share the database file because it is always only accessed by the Firebird server process.

Bet regards,

Jan

Hello Baldur 2630, I am not used to MySQL this is what the manual says: http://dev.mysql.com/doc/refman/5.1/de/alter-table.html So this should translate to some sql like alter table mytable add constraint PK_mytable PRIMARY KEY (mycol1, mycol2); But usually I would think about adding the primary key...

Hello jpgonzalez,

could you please check wether this also happens in the current stable version 7.0.3?
Best regards,

Jan