Re: [fpc-pascal] Re: SQLDB GetSchemaInfoSQL for indexes etc?

2012-04-19 Thread LacaK
Reinier Olislagers wrote / napísal(a): On 19-4-2012 11:14, LacaK wrote: Reinier Olislagers wrote / napísal(a): On 18-4-2012 8:27, LacaK wrote: for stIndexes : CatalogName, SchemaName, TableName, IndexName, ConstraintName, IsPrimary, IsUnique, IsAscending (in list are included

Re: [fpc-pascal] Re: SQLDB GetSchemaInfoSQL for indexes etc?

2012-04-19 Thread LacaK
Reinier Olislagers wrote / napísal(a): On 18-4-2012 8:27, LacaK wrote: I don't have Delphi with dbExpress here, so can't test. I did some tests in Delphi XE with DBExpress and MySQL: for stTables column names are: CatalogName, SchemaName, TableName, TableType ('T

Re: [fpc-pascal] Re: SQLDB GetSchemaInfoSQL for indexes etc?

2012-04-19 Thread LacaK
Reinier Olislagers wrote / napísal(a): Thinking about column names I would suggest, change it according to SQL-Standard (information_schema views). To be fully compatible. (because ATM we are not compatible with SQL-Standard NOR Delphi) Advantage will be, that we will be able do for example 'se

Re: RE : [fpc-pascal] Re: SQLDB GetSchemaInfoSQL for indexes etc?

2012-04-19 Thread LacaK
Ludo Brands wrote / napísal(a): Thinking about column names I would suggest, change it according to SQL-Standard (information_schema views). To be fully compatible. (because ATM we are not compatible with SQL-Standard NOR Delphi) Advantage will be, that we will be able do for example 'select *

Re: [fpc-pascal] Re: RE : RE : Re: SQLDB GetSchemaInfoSQL for indexes etc?

2012-04-19 Thread LacaK
Reinier Olislagers wrote / napísal(a): On 19-4-2012 15:02, Ludo Brands wrote: Ludo here I do not understand what do you want to say. may be, that my english is not so good ;-) Can you explain please what is your proposal regarding to stIndexes ? stIndexes is cur

Re: [fpc-pascal] Re: RE : RE : Re: SQLDB GetSchemaInfoSQL for indexes etc?

2012-04-19 Thread LacaK
Reinier Olislagers wrote / napísal(a): Proposal 1. As I'm interested in getting support for MS SQL Server and Sybase ASE into lazdatadesktop, I propose I'll go on with trying to make that work using the current sqldb structure. This will mean that a lot of code will go into new datadi

Re: [fpc-pascal] Errors compiling fixes_2.6 on win64: forgot to include dblib for mssqlconn?

2012-04-23 Thread LacaK
I added dblib only to the first group. possible solutions: 1. add dblib also to second group con: also enabled it for the others in that group. dblib uses FreeTDS which should be available/compile for at least OSX and Solaris. Win CE, iphonesim: never heard of it working there, but

Re: [fpc-pascal] SQLDB: logging all generated SQL?

2012-04-26 Thread LacaK
Can somebody tell me if that functionality is there and where to find it? Perhaps something to do with TSQLConnection.LogEvents? Look into sqldb.pp at TSQLConnection property OnLog or at global variable GlobalDBLogHook. You can register procedure, which will receive log events and you can

Re: [fpc-pascal] TBufDataSet: ApplyUpdates

2012-05-02 Thread LacaK
I saw the TBufDataSet.ApplyUpdates and it calls ApplyRecUpdate. The ApplyRecUpdate just raises an exception... Yes it is virtual method, which can be overriden by descendants There is some implementation, in some place, to work with ApplyUpdates (like a Delphi's TClientDataSet)? Yes,

Re: [fpc-pascal] TBufDataSet: ApplyUpdates

2012-05-03 Thread LacaK
Marcos Douglas wrote / napísal(a): On Thu, May 3, 2012 at 2:52 AM, LacaK wrote: I saw the TBufDataSet.ApplyUpdates and it calls ApplyRecUpdate. The ApplyRecUpdate just raises an exception... Yes it is virtual method, which can be overriden by descendants There is some

Re: [fpc-pascal] Adding method dynamically to a class

2012-06-19 Thread LacaK
Class helpers would not help ? http://wiki.freepascal.org/Helper_types -Laco. Hello, Is there a way to tell in run-time that a specific function/procedure should belong to a class ? For example, let's say I have the following class: Type T

Re: [fpc-pascal] Re: linux: shouldwehard-codeversionedorunversionedshared libraries in our apps?

2012-08-16 Thread LacaK
My plan (for linux) was: Search fbclient.so search fbclient.so.2 (2.x series of firebird) search fbclient.so.1 (1.x series of Firebird) if the library name has not been specified. So in near future we will add also fbclient.so.3 (for incomming Firebird 3) ? BTW: packages/ibase is intended t

Re: [fpc-pascal] Re: Interbase vs Firebird header translation

2012-08-17 Thread LacaK
Regarding FB2/FB3, FYI please note this snippet in the other thread: my post and Michael's reply: OT: that would be useful for another reason. Firebird 3 will introduce the BOOLEAN datatype and other innovations (encrypted connections, etc). Interbase has had BOOLEAN support for a while now.

Re: [fpc-pascal] TSQLDBLibraryLoader committed for SQLDB

2012-08-21 Thread LacaK
Hi Michael, ok, there is in sqldblib unit setter function "SetCype" ... may be, that there is typo and better name would be "SetCType" ? If you decide to correc it, then please change also all CType (Ctype, CTYpe,) occurences to "CType" ;-)) -Laco. Hi, After recent discussions about which li

Re: [fpc-pascal] Re: SDFDataset users!?

2012-09-24 Thread LacaK
AS I understand, there are in sdfdata.pp: TFixedFormatDataSet - for SDF = "(*S*tandard *D*ata *F*ormat) A simple file format that uses fixed length fields." TSdfDataSet - for variable field length, where fields are delimited by Delimiter (and probably quoted) ... we can call it "CSV" and here

Re: [fpc-pascal] Problems with Postgresql Character Encoding

2012-09-26 Thread LacaK
Mark Morgan Lloyd wrote / napísal(a): Andrew Brunner wrote: My cloud file/folder sync client desktop app builds and maintains a manifest of all files and folders from a specified starting point. I use this manifest to synchronize disk entries across devices. It uses HTTP requests and XML to

Re: [fpc-pascal] Problems with Postgresql Character Encoding

2012-09-26 Thread LacaK
May be that better would be add support for PQsetClientEncoding into TPQConnection ... I can look at it if you want. Patch is here http://bugs.freepascal.org/view.php?id=22985 (I did only basic testing) -Laco. ___ fpc-pascal maillist - fpc-pas

Re: [fpc-pascal] Using database-specific functionality with TSQLConnector

2012-10-04 Thread LacaK
Hm, i see these ways: 1. Add CreateDB/DropDB methods to SQLConnector (like others methods, CreateDB is virtual at TSQLConnection level): procedure TSQLConnector.CreateDB; begin CheckProxy; FProxy.CreateDB; end; 2. Add getter for Proxy property: function TSQLConnector.GetProxy: TSQLConnection

Re: [fpc-pascal] What is the size of AnsiChar

2012-11-05 Thread LacaK
ik wrote / napísal(a): On Mon, Nov 5, 2012 at 1:18 PM, Tomas Hajny wrote: On Mon, November 5, 2012 11:49, ik wrote: Hello Ido, As I understand, AnsiString and AnsiChar contain the environment type of string (it can be ISO8859x, utf-8 etc...). If that so, how can I know the size (in

Re: [fpc-pascal] Free Pascal 2.6.2 rc1

2012-11-22 Thread LacaK
Mark Morgan Lloyd wrote / napísal(a): Marco van de Voort wrote: Hello, We have placed the first release-candidate of the Free Pascal Compiler version 2.6.2 on our ftp-servers. You can help improve the upcoming 2.6.2 release by downloading and testing this release. If you want you can report w

Re: [fpc-pascal] Free Pascal 2.6.2 rc1

2012-11-23 Thread LacaK
Mark Morgan Lloyd wrote / napísal(a): Marco van de Voort wrote: Hello, We have placed the first release-candidate of the Free Pascal Compiler version 2.6.2 on our ftp-servers. You can help improve the upcoming 2.6.2 release by downloading and testing this release. If you want you can report w

Re: [fpc-pascal] Dataset indexdefs.find: documentation wrong?

2012-12-02 Thread LacaK
Reinier Olislagers wrote / napísal(a): With this code: procedure SortBufDataSet(DataSet: TBufDataSet; const FieldName: string); var Index_Name: string; begin Index_Name := FieldName + '__IdxA'; if (DataSet.IndexDefs.Find(Index_Name)<>Nil) then ... the last line throws an exception if the i

Re: [fpc-pascal] GetTableNames in TSQLConnection / Postgresql

2012-12-14 Thread LacaK
Hi John, Thus schema name is not selected for postresql, nor is it returned for any connection. as only the field specified by AReturnField, in this case table_name, is added to the output list. Note that pg_class does not have an easy access to the schema/owner by name, it would require a jo

Re: [fpc-pascal] GetTableNames in TSQLConnection / Postgresql

2012-12-17 Thread LacaK
I think, that if this view(s) is(are) presented in all versions of PostgreSQL which fcl-db is going to support, that it is no problem use them (I must note, that my preffered way is follow sql standard INFORMATION_SCHEMA views at least in column naming) The equivalent INFORMATION_SCHEMA view

Re: [fpc-pascal] GetTableNames in TSQLConnection / Postgresql

2012-12-17 Thread LacaK
Reinier Olislagers wrote / napísal(a): On 16-12-2012 2:27, John wrote: @Reinier: Analysis: As far as I can work out, a call to GetTableNames calls GetDBInfo, with parameters ASchemaType : TSchemaType - This specifies what info we want - user tables, sys tables, procedures, columns e

Re: [fpc-pascal] GetTableNames in TSQLConnection / Postgresql

2012-12-17 Thread LacaK
michael.vancann...@wisa.be wrote / napísal(a): On Mon, 17 Dec 2012, LacaK wrote: 2) The simple way to get the schemas would be to simply 'select ... schemaname||'.'||relname as table_name ... from pg_stat_user_tables. This would be a change ONLY to the sql in pqconnect

Re: [fpc-pascal] GetTableNames in TSQLConnection / Postgresql

2012-12-17 Thread LacaK
michael.vancann...@wisa.be wrote / napísal(a): On Mon, 17 Dec 2012, LacaK wrote: michael.vancann...@wisa.be wrote / napísal(a): On Mon, 17 Dec 2012, LacaK wrote: 2) The simple way to get the schemas would be to simply 'select ... schemaname||'.'||relname as tabl

Re: [fpc-pascal] GetTableNames in TSQLConnection / Postgresql

2012-12-17 Thread LacaK
michael.vancann...@wisa.be wrote / napísal(a): On Mon, 17 Dec 2012, LacaK wrote: But original question AFAIU was about: what should GetTableNames return (schema query can return multiple columns, but what column use when fill list of table names)? GetTableNames return list of table names

Re: [fpc-pascal] GetTableNames in TSQLConnection / Postgresql

2012-12-17 Thread LacaK
For now I added in rev.23163 schema name into query for PostgreSQL (so no empty schema name is returned, but valid schema name) Here I understand: stTables - list of all tables, which may include system tables (it is not clear from documentation)? stSysTables - list of ONLY system tables (not v

Re: [fpc-pascal] Re: GetTableNames in TSQLConnection / Postgresql

2012-12-21 Thread LacaK
John wrote / napísal(a): On 12/21/2012 10:37 PM, Tomas Hajny wrote: On Fri, December 21, 2012 11:59, Reinier Olislagers wrote: On 18-12-2012 10:49, Tomas Hajny wrote: On Tue, December 18, 2012 09:35, michael.vancanneyt-0is9kj9s...@public.gmane.org wrote: On Tue, 18 Dec 2012, John wrote: you

Re: [fpc-pascal] download link on viewvc pages is missing

2013-02-12 Thread LacaK
Hi, the "(download)" link (together with the "(as text)") link that used to be next to "(view)" and "(annotate)" in viewvc revisions logs are missing, can this be enabled, please? Yes it will be good to have it back ;-) +1 -Laco. ___ fpc-pascal

Re: [fpc-pascal] download link on viewvc pages is missing

2013-02-13 Thread LacaK
Michael Van Canneyt wrote / napísal(a): On Wed, 13 Feb 2013, LacaK wrote: Hi, the "(download)" link (together with the "(as text)") link that used to be next to "(view)" and "(annotate)" in viewvc revisions logs are missing, can this be enabled, pl

Re: [fpc-pascal] download link on viewvc pages is missing

2013-02-13 Thread LacaK
Michael Van Canneyt wrote / napísal(a): On Wed, 13 Feb 2013, LacaK wrote: Michael Van Canneyt wrote / napísal(a): On Wed, 13 Feb 2013, LacaK wrote: Hi, the "(download)" link (together with the "(as text)") link that used to be next to &qu

[fpc-pascal] Compiler define MAC or MACOS ?

2013-02-25 Thread LacaK
Hi, on documentation http://www.freepascal.org/docs-html/prog/progap7.html#x316-331000G there is : Classic Macintosh MAC but in sources is used: MACOS So may be, that documentation should be updated ? TIA -Laco. ___ fpc-pascal maillist - fpc-pascal@l

Re: [fpc-pascal] Problem using Free-Pascal in Win98

2013-04-03 Thread LacaK
Where do you experience this behavior? I use Lazarus 1.0.8 + FPC 2.6.2 under Win98 and in IDE for me it works as expected also in small test application. With EN keyboard: - CapsLock=ON: Shift+9=(, same with CapsLock=OFF -Laco. To whom it may concern: I've downloaded two versions of Free Pas

Re: [fpc-pascal] How can retrive value from OUT parameter?

2013-04-22 Thread LacaK
Toru Takubo wrote / napísal(a): Hi Dmitry, Thank you very much for your advice. I am sure your code should work, but unfortunately I can not modify the existing stored procedures. I will explain what I have been trying so far. Suppose you are using the following stored procedure,

Re: [fpc-pascal] SqlDB vs Zeos: TDataset.FieldDefs[].Size

2013-04-22 Thread LacaK
Graeme Geldenhuys wrote / napísal(a): On 2013-04-20 10:11, Ludo Brands wrote: TFieldDef.Size is expressed in bytes. Zeos, IIRC, assumes a conversion from any charset to utf8 could be made. Since UTF8 is up to 4 bytes per char, a VarChar(10) can need up to 40 bytes to be represented in the

Re: [fpc-pascal] PostgreSQL: ERROR: operator does not exists: uuid = text

2013-09-05 Thread LacaK
Michael Van Canneyt wrote / napísal(a): On Wed, 4 Sep 2013, silvioprog wrote: Hello, I can't understand how to open a query filtering by a field of type GUID. The error message is below (translated from BR to US): TPQConnection: Preparation of query failed. (PostgreSQL: ERROR: operator

Re: [fpc-pascal] TMemoField saving empty strings as '' (double quote)

2013-09-10 Thread LacaK
Hi Silvio, I cann't reproduce your error in 2.7.1 (trunk) Fix in rev.25411 closes also problem you mentioned. (but before this rev. problem existed) But now I get another error, which says that there is "no insert query specified" because all fields in posted row are empty (null) (which is okay

Re: [fpc-pascal] TMemoField saving empty strings as '' (double quote)

2013-09-10 Thread LacaK
silvioprog wrote / napísal(a): 2013/9/10 silvioprog mailto:silviop...@gmail.com>> 2013/9/10 Sven Barth mailto:pascaldra...@googlemail.com>> Am 10.09.2013 13:47, schrieb silvioprog: 2013/9/10 LacaK mailto:la...@zoznam.sk>> Hi Silvio,

Re: [fpc-pascal] TMemoField saving empty strings as '' (double quote)

2013-09-11 Thread LacaK
silvioprog wrote / napísal(a): 2013/9/10 silvioprog mailto:silviop...@gmail.com>> 2013/9/10 Sven Barth mailto:pascaldra...@googlemail.com>> Am 10.09.2013 13:47, schrieb silvioprog: 2013/9/10 LacaK mailto:la...@zoznam.sk>> Hi Silvio,

Re: [fpc-pascal] TMemoField saving empty strings as '' (double quote)

2013-09-11 Thread LacaK
silvioprog wrote / napísal(a): 2013/9/11 LacaK mailto:la...@zoznam.sk>> Strange ;-) Can you please attach and send your bufdataset.pas ? -Laco. Yes: http://pastebin.com/nqVnXAs5 This is not latest version. Correct version is here: http://svn.freepascal.org/cgi-bin/view

Re: [fpc-pascal] TMemoField saving empty strings as '' (double quote)

2013-09-11 Thread LacaK
silvioprog wrote / napísal(a): 2013/9/11 LacaK mailto:la...@zoznam.sk>> silvioprog wrote / napísal(a): Now doing more tests. I see, that in pgAdmin when I use right click on table and use "View Data" then '' (two single quotes) are shown in TEXT column,

Re: [fpc-pascal] how to directly access field/record value of TBufDataSet?

2013-09-30 Thread LacaK
Dennis Poon wrote / napísal(a): Also, how do I use the procedure LoadFromStream(AStream : TStream; Format: TDataPacketFormat = dfAny)? Especially, I don't understand the TDataPacketFormat parameter. Using Format parameter you can signal to DatapacketReader in which format expect data (df

Re: [fpc-pascal] how to directly access field/record value of TBufDataSet?

2013-10-01 Thread LacaK
Dennis Poon wrote / napísal(a): Also, how do I use the procedure LoadFromStream(AStream : TStream; Format: TDataPacketFormat = dfAny)? Especially, I don't understand the TDataPacketFormat parameter. Using Format parameter you can signal to DatapacketReader in which format expect data (df

Re: [fpc-pascal] SqlDB+Firebird - incomplete sql error messages

2013-10-17 Thread LacaK
I remember that similar problem can be somehow related to firebird.msg and firebird.dll versions mismasch or so. See http://www.firebirdfaq.org/faq288/ L. Hi, When I run sql insert statements (that I know will cause an error) using the FlameRobin tool, I get a detailed error message mentionin

Re: [fpc-pascal] Lazarus and fpc trunk

2013-10-22 Thread LacaK
Jonas Maebe wrote / napísal(a): On 22 Oct 2013, at 14:10, Michael Van Canneyt wrote: A Lazarus built with the current trunk FPC is nearly unworkable. (I suspect the changes in string handling are to blame for that) There were severe stability problems with FPC trunk r24953 till r25684 beca

Re: [fpc-pascal] DataSet.Locate: different behaviour between FPC 2.6.2 and 2.7.1 (rev. 2013/09/01)

2013-10-24 Thread LacaK
silvioprog wrote / napísal(a): Hello, This morning, I compiled a code using FPC (Windows, rev. 2013/09/01), after that, my tests using dataset.locate has stopped. The Locate method locates record, even when it does not exists. The problem occurs only with varchar fields, in integer fields i

Re: [fpc-pascal] TBookmark Type Change Status Request

2013-11-18 Thread LacaK
AFAIS this change is not merged to FPC 2.6.3, so I think, that it will NOT be a part of 2.6.4 L. Does anyone have an update on which release the TBookmark type change from pointer to TBytes is going to be rolled out? I have heard that it will not now be in 2.6.4. It's not that I want to use thi

Re: [fpc-pascal] how to install sqlite server side library on CentOS

2013-12-08 Thread LacaK
Dennis Poon wrote / napísal(a): Jonas Maebe wrote: On 06 Dec 2013, at 18:45, Dennis Poon wrote: My server program written in fpc uses sqlite3 and in ubuntu, I just need to apt-get install libsqlite3-dev but in centos, the libsqlite3-dev does not exist and the client lib after yum i

Re: [fpc-pascal] Does TBufDataSet support Blob or memo field?

2014-01-13 Thread LacaK
AFAIR this is so. (we can call it bug ;-)) Data are not there until you Post record. After Post you will see data there, right? -Laco. I created a TMemoField in TBufDataSet but no matter I do: 1) Field.asString := 'some value' or 2) Field.LoadFromStream(someStream). Afterwards, this F.AsString

Re: [fpc-pascal] Does TBufDataSet support Blob or memo field?

2014-01-13 Thread LacaK
> All the other usual types (e.g. integer, string, datetime) work Yes it is expected behavior>except ftMemo and ftblob.> Yes it is not consistent and from my POV it is bug.I will look (next week or two) if it can be fixed, but I have doubts, that it will not be so easy :-))-Laco. __

Re: [fpc-pascal] Does TBufDataSet support Blob or memo field?

2014-01-16 Thread LacaK
I checked my code again and I found I did post after I check the blob/memo field values. I think it is probably a bug, rather than a feature as all fields should be the same: values get updated even without calling post. Yes, I agree. As I wrote I will look at it ... if I find smart solutio

[fpc-pascal] DecimalSeparator automatic change ?

2014-01-17 Thread LacaK
Hi, I have strange problem, I have application on Windows 2012 Server, where is set locale to Slovak (DecimalSeparator is comma) In my application in DataModuleCreate I explicitly set FormatSettings.DecimalSeparator='.' (dot) All works as expected (decimal numbers are formated with "dot"), but

Re: [fpc-pascal] DecimalSeparator automatic change ?

2014-01-17 Thread LacaK
Michael Van Canneyt wrote / napísal(a): On Fri, 17 Jan 2014, LacaK wrote: Hi, I have strange problem, I have application on Windows 2012 Server, where is set locale to Slovak (DecimalSeparator is comma) In my application in DataModuleCreate I explicitly set FormatSettings.DecimalSeparator

Re: [fpc-pascal] Does TBufDataSet support Blob or memo field?

2014-01-28 Thread LacaK
I checked my code again and I found I did post after I check the blob/memo field values. I think it is probably a bug, rather than a feature as all fields should be the same: values get updated even without calling post. Yes, I agree. As I wrote I will look at it ... if I find smart solut

Re: [fpc-pascal] SVN revisions and builds

2014-02-05 Thread LacaK
Current trunk versions of Lazarus should be able to build using a current FPC development version. But on ftp://ftp.freepascal.org/pub/lazarus/snapshots/ are only old versions for FPC 2.7.1, 2.6.3 So I guess, that there must be any problem ... L.

Re: [fpc-pascal] TSQLQuery UniDirectional and SaveToStream

2014-02-05 Thread LacaK
Dimitrios Chr. Ioannidis wrote / napísal(a): Hi all, i will appreciate a little help / advice / anything for the following problem i'm having. I need to use the xmldatapacketreader to transfer datasets between free pascal and delphi. The problem i'm having is that i can't use UniDirec

Re: [fpc-pascal] TSQLQuery UniDirectional and SaveToStream

2014-02-06 Thread LacaK
Dimitrios Chr. Ioannidis wrote / napísal(a): Hi, Στις 6/2/2014 9:10 πμ, ο/η LacaK έγραψε: Dimitrios Chr. Ioannidis wrote / napísal(a): Hi all, i will appreciate a little help / advice / anything for the following problem i'm having. I need to use the xmldatapacketreader to tra

Re: [fpc-pascal] Database questions re 21579: [Patch] Dbtestframework compilationf fixes for Win64

2012-03-29 Thread LacaK
Reinier Olislagers wrote / napísal(a): On 28-3-2012 12:22, Reinier Olislagers wrote: On 28-3-2012 11:36, Sven Barth wrote: Am 28.03.2012 11:12, schrieb Reinier Olislagers: On 28-3-2012 11:04, Sven Barth wrote: (b) Maybe nobody needed it yet. I myself might be the firs

[fpc-pascal] Win64 and currency

2012-03-30 Thread LacaK
Hi *, I encounter strange thing under FPC 2.7.1 and Win64 target. Can anybody test this program: const test: array[0..0] of currency = (-10); var c:currency; begin c := -10; writeln(c); writeln(test[0]); readln; end. Results: -1.000

Re: [fpc-pascal] Win64 and currency

2012-04-01 Thread LacaK
Thanks! I posted comment to: http://bugs.freepascal.org/view.php?id=21091 -Laco. In our previous episode, Pierre Free Pascal said: if you usee -Aas and -al you will see that TEST is just .quad -10 which is wrong of course... Using -10.0 fixes the bug for now if you really need this corre

Re: [fpc-pascal] SQLDB GetSchemaInfoSQL for indexes etc?

2012-04-17 Thread LacaK
type TSchemaType = (stNoSchema, stTables, stSysTables, stProcedures, stColumns, stProcedureParams, stIndexes, stPackages); is used in the GetSchemaInfoSQL function: Does anybody know what stIndexes, stProcedureParams and stPackages should return and when they would be used? stIndexes: get a

Re: [fpc-pascal] SQLDB GetSchemaInfoSQL for indexes etc?

2012-04-17 Thread LacaK
Thanks Michael. Function signature is GetSchemaInfoSQL(SchemaType : TSchemaType; SchemaObjectName, SchemaPattern : string) : string; ... assuming SchemaObjectName would be used similar to the existing code and would specify table name (stIndexes)/stored proc name (stProcedureParams)? See h

Re: [fpc-pascal] Re: SQLDB GetSchemaInfoSQL for indexes etc?

2012-04-17 Thread LacaK
Does it perhaps follow ODBC conventions or something? or SQL-Standard INFORMATION_SCHEMA views ;-) L. ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] Re: SQLDB GetSchemaInfoSQL for indexes etc?

2012-04-17 Thread LacaK
I don't have Delphi with dbExpress here, so can't test. I did some tests in Delphi XE with DBExpress and MySQL: for stTables column names are: CatalogName, SchemaName, TableName, TableType ('TABLE') (in FPC (for IBConnection) we have catalog_name, schema_name, table_name, table_type) f

Re: [fpc-pascal] Re: SQLDB GetSchemaInfoSQL for indexes etc?

2012-04-19 Thread LacaK
Reinier Olislagers wrote / napísal(a): On 18-4-2012 8:27, LacaK wrote: I don't have Delphi with dbExpress here, so can't test. I did some tests in Delphi XE with DBExpress and MySQL: for stTables column names are: CatalogName, SchemaName, TableName, TableType ('T

Re: [fpc-pascal] Mirror empty

2014-03-05 Thread LacaK
Mattias Gaertner wrote / napísal(a): On Wed, 05 Mar 2014 22:01:37 +0100 Florian Klämpfl wrote: Am 05.03.2014 19:26, schrieb Mattias Gaertner: The fpc mirror http://www.hu.freepascal.org/ is empty. http://ftp.hu.freepascal.org/lazarus is available again. Thank You!

Re: [fpc-pascal] TSQLQuery.ApplyUpdates problem with UTF-8

2014-03-18 Thread LacaK
Dennis Poon wrote / napísal(a): Dennis Poon wrote: Michael Van Canneyt wrote: On Fri, 14 Mar 2014, Dennis Poon wrote: the content appeared as garbage. I already specified the CHARSET=utf8 in the Create Table SQL. Did you set the TSQLConnection.Charset property to UTF8 as well ?

Re: [fpc-pascal] TSQLQuery.ApplyUpdates problem with UTF-8

2014-03-18 Thread LacaK
Dennis Poon wrote / napísal(a): Dennis Poon wrote: Michael Van Canneyt wrote: On Fri, 14 Mar 2014, Dennis Poon wrote: the content appeared as garbage. I already specified the CHARSET=utf8 in the Create Table SQL. Did you set the TSQLConnection.Charset property to UTF8 as well ?

Re: [fpc-pascal] TSQLQuery.ApplyUpdates problem with UTF-8

2014-03-20 Thread LacaK
Dennis Poon wrote / napísal(a): I tried, the results are: @@character_set_client : utf8 @@character_set_connection : latin1 @@character_set_database : latin1 Dennis, do you received my reply?: IMO @@character_set_connection is wrong and must be utf8. I will try fix it, but fir

Re: [fpc-pascal] TSQLQuery.ApplyUpdates problem with UTF-8

2014-03-21 Thread LacaK
Dennis Poon wrote / napísal(a): I tried, the results are: @@character_set_client : utf8 @@character_set_connection : latin1 @@character_set_database : latin1 Dennis, do you received my reply?: IMO @@character_set_connection is wrong and must be utf8. I will try fix it, but first c

Re: [fpc-pascal] TSQLQuery.ApplyUpdates problem with UTF-8

2014-03-24 Thread LacaK
Dennis Poon wrote / napísal(a): LacaK wrote: Dennis Poon wrote / napísal(a): I tried, the results are: @@character_set_client : utf8 @@character_set_connection : latin1 @@character_set_database : latin1 Dennis, do you received my reply?: IMO @@character_set_connection is

Re: [fpc-pascal] Blobtype fix - correct?

2014-04-24 Thread LacaK
Hi, I know , that I am bit late ;-), but: - for compatibility reasons I would choose another path (mentioned by Michael as "second"). As it was mentioned in comments in bug tracker there are two similar methods: -- SetDataType (protected) -- SetFieldType (public with checks ... see in fields.in

Re: [fpc-pascal] MSSQL and ftAutoInc: FPC 2.6.5 changes the behavior of 2.6.2 but AutoInc not works yet

2014-04-24 Thread LacaK
Do you have tried for ftAutoInc field simply set ReadOnly:=False; ? -Laco. P.S. there is feature request about automatic fetching of new values of idnetity columns, but implementing it in generic way for all supported SQLConnections is not trivial ;-) Hi, I'm using 2.6.5 (fixes_2_6) now but

Re: [fpc-pascal] MSSQL and ftAutoInc: FPC 2.6.5 changes the behavior of 2.6.2 but AutoInc not works yet

2014-04-25 Thread LacaK
Martin Schreiber wrote / napísal(a): On Friday 25 April 2014 07:46:23 LacaK wrote: Do you have tried for ftAutoInc field simply set ReadOnly:=False; ? -Laco. P.S. there is feature request about automatic fetching of new values of idnetity columns, but implementing it in generic way for all

[fpc-pascal] Inconsistent results currency - extended ?

2014-04-29 Thread LacaK
Hi, I catch strange behavior, which I can not understand ;-) I have 2 PC on both I have installed Lazarus 1.2.2 + FPC 2.6.4 (official release) 1st PC has Windows 98 2nd PC has Windows Vista (32 bit) I have this program: = var c: currency; e: extended; begin c:=-

Re: [fpc-pascal] Inconsistent results currency - extended ?

2014-04-29 Thread LacaK
Pierre Muller -Message d'origine- De : fpc-pascal-boun...@lists.freepascal.org [mailto:fpc-pascal- boun...@lists.freepascal.org] De la part de LacaK Envoyé : mardi 29 avril 2014 10:23 À : FPC-Pascal users discussions Objet : [fpc-pascal] Inconsistent results currency - extended ? Hi,

[fpc-pascal] overloading function

2014-05-01 Thread LacaK
Hi, I am trying understand how FPC determines which version of overloaded function to call. Take as example these 2 functions (from SysUtils): 1. function StrPLCopy(Dest: PChar; Source: string; MaxLen: SizeUInt): PChar; overload; 2. function StrPLCopy(Dest: PWideChar; const Source: UnicodeStrin

Re: [fpc-pascal] overloading function

2014-05-02 Thread LacaK
>> I am trying understand how FPC determines which version of >>overloaded>> function to call.>> Take as example these 2 functions (from SysUtils):>> 1. function StrPLCopy(Dest: PChar; Source: string; MaxLen: >>SizeUInt):>> PChar; overload;>> 2. function StrPLCopy(Dest: PWideChar; const Source: Uni

Re: [fpc-pascal] Inconsistent results currency - extended ?

2014-05-03 Thread LacaK
FPC on Win98 incorrectly stores currency constant in generated EXE file, so varible "c" is initialised with wrong value ...(see my first email with results)Thanks-Laco.> Tested with FPC 2.6.4 .> > LacaK are you sure you compile with the same version.> > To me everything looks

[fpc-pascal] Currency constant wrongly stored in generated EXE ? was: Re: Inconsistent results currency - extended ?

2014-05-06 Thread LacaK
Bruno Krayenbuhl wrote / napísal(a): 2 - Difference between 2.6.4 on Win98 and WinXP. I suspect that these 2 are on different computers and thus do not have exactly the same floating point unit. Yes Win 98 is on PC with Intel Pentium 4 CPU and Win XP on PC with Intel Core 2 Duo CPU But l

Re: [fpc-pascal] overloading function

2014-05-06 Thread LacaK
Hi again, I reply also to fpc-devel list (excuse me, if it is off-topic), because I would like understand wat is going on. I attach also simple test program. I use FPC 2.6.4 but I think, that same happens also with fresh 2.7.1 Thanks -Laco. On 02.05.2014 07:45, LacaK wrote: Hi, I am trying

Re: [fpc-pascal] Currency constant wrongly stored in generated EXE ? was: Re: Inconsistent results currency - extended ?

2014-05-06 Thread LacaK
Bruno Krayenbuhl wrote / napísal(a): I have absolutely no idea of how the compiler does translate Currency constant to code, sorry. May be it uses the FPU when translating from String representation to assembler value, but I have absolutely no idea where that would be done in the compiler.

Re: [fpc-pascal] overloading function StrPLCopy

2014-05-07 Thread LacaK
n, I reply also to fpc-devel list (excuse me, if it is off-topic), because I would like understand wat is going on. I attach also simple test program. I use FPC 2.6.4 but I think, that same happens also with fresh 2.7.1 Thanks -Laco. On 02.05.2014 07:45, LacaK wrote: Hi, I am trying understa

Re: [fpc-pascal] Currency constant wrongly stored in generated EXE?

2014-05-12 Thread LacaK
You have troubled me seriously, so I have dug in the compiler source. :-) It appears that when parsing the source, Currency constants are cast to type BestReal (EXTENDED on I386) before being converted to the 8 byte currency written to the PPU or EXE or whatever is done. it was my ex

Re: [fpc-pascal] Currency constant wrongly stored in generated EXE?

2014-05-12 Thread LacaK
Did you check that infamous coprocessor Pentium FDIV bug? http://en.wikipedia.org/wiki/Pentium_FDIV_bug#Affected_models The even give values to test: The correct value is 4195835/3145727 = 1.333820449136241002 However, the value returned by the flawed Pentium is incorrect at or bey

Re: [fpc-pascal] Currency constant wrongly stored in generated EXE?

2014-05-14 Thread LacaK
Lets restate the hole thing, considering unit ncon.pas and pexpr.pas units in FPC 2.6.4 compiler. 1° It is not possible, without using some ad hoc adjustements, to have always an EXACT CURRENCY stored in a DOUBLE or EXTENDED because Double or Extended being expressed as Sign*2^exp*Base2(n). Ju

Re: [fpc-pascal] Database Metadata proposal

2014-06-01 Thread LacaK
Hi Daniel, If I understand correctly, when you will use new GetObjectNames then you must itterate throught returned collection to obtain "schema names" + "object names" (f.e. "table names"). IMO very similar result you can get also with existing implementation, when you use: with SQLQuery1

Re: [fpc-pascal] Database Metadata proposal

2014-06-02 Thread LacaK
Daniel Gaspary wrote / napísal(a): On Mon, Jun 2, 2014 at 3:01 AM, LacaK wrote: IMO very similar result you can get also with existing implementation, when you use: Yes, this is the way GetDBInfo do, but it's not public, and never return schema. Code which I have attached uses

Re: [fpc-pascal] Database Metadata proposal

2014-06-02 Thread LacaK
Michael Van Canneyt wrote / napísal(a): On Mon, 2 Jun 2014, LacaK wrote: Daniel Gaspary wrote / napísal(a): On Mon, Jun 2, 2014 at 3:01 AM, LacaK wrote: IMO very similar result you can get also with existing implementation, when you use: Yes, this is the way GetDBInfo do, but it&#

Re: [fpc-pascal] Problem with StrToCurrDef()

2014-06-05 Thread LacaK
silvioprog wrote / napísal(a): Hello, I'm trying to convert 'curr > str' and 'str to curr' respectively, but I've got a problem with StrToCurrDef(). See my test below: See: http://www.freepascal.org/docs-html/rtl/sysutils/strtocurr.html Or: http://docwiki.embarcadero.com/VCL/XE/en/SysUtils.St

Re: [fpc-pascal] Support for new MS SQL 2008 datetime data types - Revision 27981 - by lacaK

2014-06-16 Thread LacaK
Marcos Douglas wrote / napísal(a): On Mon, Jun 16, 2014 at 11:36 AM, Michael Van Canneyt wrote: On Mon, 16 Jun 2014, Reinier Olislagers wrote: On 16/06/2014 15:45, Marcos Douglas wrote: Hi Laco, About this update: http://svn.freepascal.org/cgi-bin/viewvc.cgi?view=revision&re

[fpc-pascal] ReadXMLFile in fcl-xml package

2014-09-18 Thread LacaK
Hi, I use ReadXMLFile from fcl-xml package to read XML file in UTF-8 encoding. Then I parse Nodes and use TextContent property which is string in system encoding ... but I need it in UTF-8 encoding. So I use again UTF8Encode(Node.TextContent). Is there any SIMPLE way how to say that ReadXMLFile

Re: [fpc-pascal] Memory leaks in the oracleconnection.pp unit (fpc-2.6.4/packages/fcl-db/src/sqldb/oracle)

2014-10-14 Thread LacaK
Hi, there was many changes in trunk version of oracleconnection.pp, so first please look at it. Then please use db test suite located in fcl-db/tests ... there is dbtestframework. -Laco. Hello! I found severe bugs in the current release (2.6.4) of fcl-db oracle connection module leading to me

Re: [fpc-pascal] MS SQLConn - Possible memory leak in driver (dblib or libiconv2)

2014-10-19 Thread LacaK
Hi Marcos, First useful thing would be isolate source of memory leak. If it is on FreePascal side, then we must search there, if it is on FreeTDS side, then we must report bug to FreeTDS project. You can use version of dblib.dll, which does not use libiconv2, so we can isolate it. Do you not use

Re: [fpc-pascal] raw printing throught USB port / WINDOWS

2014-12-16 Thread LacaK
You can use: Printer.RawMode := True; Printer.BeginDoc; Printer.EndDoc; -Laco. I need a solution (unit?) to access printer (matricial like LX80, LX300 and so on) in raw mode throught USB port directly from FPC program build in mode win32 or win64. apreciate any ideia thanks

Re: [fpc-pascal] raw printing throught USB port / WINDOWS

2014-12-16 Thread LacaK
Is the printer already known to Windows (can you print to that printer from others windows applications) ? If yes, then you can use: Printer.SetPrinter('Printer name'); -Laco. Em 16.12.2014 09:27, LacaK escreveu: You can use: Printer.RawMode := True; Printe

Re: [fpc-pascal] Some features for FPC 3.0?

2015-02-17 Thread LacaK
Yes. Snapshot is very good, but unfortunately it seems stopped. =( +1 The snapshots could solve the necessity of RCs versions. +1 -Laco. ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/lis

[fpc-pascal] Functions for int128rec ?

2015-02-18 Thread LacaK
Hi, I noticed that there is "int128rec" type, but I do not found any support routines which can do operations like multiplication, addition with this type. Is there something or is planed any integrated support in FPC for "int128" ? (To be precise I need convert large integer (larger than int64

  1   2   3   >