User:BigChimp

Who?

Just a guy fiddling with computers. I don't have a Delphi or formal programming background... but Lazarus/FreePascal really works for me!

Database test framework run

Ran database test framework for FPC trunk on 25 September 2012.

Remarks on some TTestFieldTypes tests:

• TTestFieldTypes.TestInsertLargeStrFields tries to create a 16000 character field; UTF8 encoded Firebird dbs only support up to about 8000 characters (32768 bytes). So the same problem as the UTF8 field length issue.
• TTestFieldTypes.TestCrossStringDateParam: exception invalid variant type cast=>conversion error or something? would require stepping through the code to find out what's wrong I suppose
• TTestFieldTypes.TestTemporaryTable: fixed test; Firebird supports temp tables
• TTestFieldTypes.TestLargeRecordSize: fields are 8192 chars; same issue as TTestFieldTypes.TestInsertLargeStrFields

todo: do the rest

SQLDB internals

dsMaxStringSize (e.g. in fields.inc) indicates maximum (string field)? size that an internal buffer provides. If a field is larger, a temporary buffer will need to be used.

Interesting things

• Gdb 7.3.50 appears broken for i386 running with Lazarus since about 1.1; get invalid application or something when running under debugger. 7.2 (as distributed with current installers) does seem to work.

Perhaps worth having a look:

• Firebird 3 driver (split out from ib); perhaps based on C++ code using SWIG
• DB performance/stress testing
• Visual SQL Query designer (see forum posts) => incorporate into database desktop

LCL documentation link:

• [ [ doc:lcl/the/path/to/the/htmlfile.html ] ], e.g.
• doc:lcl/extctrls/multi-pagecontrols.html

• Internal error 200306067: can happen with PPU loading (stale PPUs etc). Compile with -vut to show which unit loads are attempted.