Search found 4 matches

by arnix
03.02.2009, 16:14
Forum: 6.6 - stable
Topic: Database Synchronizing (Speed Problem)
Replies: 3
Views: 555

Sorry for late response. trupka , Use COPY instead INSERT (see Postgres docs for details) I'm copying _from_ postgresql, not _to_. Also, try to wrap all inserts inside one transaction That one was a good advice, I also removed the progerss bar update routine after every ExecSQL, and now I do that af...
by arnix
23.01.2009, 15:09
Forum: 6.6 - stable
Topic: Database Synchronizing (Speed Problem)
Replies: 3
Views: 555

Database Synchronizing (Speed Problem)

Hi, My Desktop application that is using PostgreSQL needs time to time synchronize data to Pocket PC application that uses SQLite. All is working perfectly, but I would like to increase the speed of synchronization. Currently I'm using something like this: procedure TRapiCopyForm.GenerateUpdateDBFor...
by arnix
20.06.2008, 12:10
Forum: Feature Requests
Topic: Unicode support?
Replies: 4
Views: 3835

OK, solved it. function GetAsWideString(Field: TField): WideString; {$IFDEF COMPILER_10_UP} begin if (Field.ClassType = TMemoField{TNT-ALLOW TMemoField}) then // Result := VarToWideStr(Field.AsVariant) { works for NexusDB BLOB Wide } Result := UTF8Decode(Field.AsWideString) // arnix else Result := F...
by arnix
20.06.2008, 11:15
Forum: Feature Requests
Topic: Unicode support?
Replies: 4
Views: 3835

This is working well with edit boxes and grids but not with memos. Here is my modified code. function GetWideDisplayText(Field: TField): WideString; var WideField: IWideStringField; begin if Field.GetInterface(IWideStringField, WideField) then Result := WideField.WideDisplayText else if (Field is TW...