On 17-4-2012 10:36, Reinier Olislagers wrote:
> In sqldb, this:
>
> type TSchemaType = (stNoSchema, stTables, stSysTables, stProcedures,
> stColumns, stProcedureParams, stIndexes, stPackages);
> is used in the GetSchemaInfoSQL function:
>
> I noticed stIndexes, stProcedureParams and stPackages do
On 17-4-2012 13:33, LacaK wrote:
>
>>
>> Does it perhaps follow ODBC conventions or something?
>>
> or SQL-Standard INFORMATION_SCHEMA views ;-)
While I know that standard exists - I can tell without looking it up
that the integer table_type column we're using is a vendor specific
extra - that'
On 17-4-2012 12:58, LacaK wrote:
>> ... assuming SchemaObjectName would be used similar to the existing code
>> and would specify table name (stIndexes)/stored proc name
>> (stProcedureParams)?
> See
> http://docwiki.embarcadero.com/VCL/XE2/en/SqlExpr.TCustomSQLDataSet.SetSchemaInfo
Thanks Laco, ve
On 19-4-2012 9:41, michael.vancanneyt-0is9kj9s...@public.gmane.org wrote:
> On Thu, 19 Apr 2012, Reinier Olislagers wrote:
>> Plans
>> =
>> I'll focus on getting lazdatadesktop/datadict support for MSSQL/Sybase
>> running first; afterwards we can look at the things we can add for other
>> datab
On Tue, 17 Apr 2012, Reinier Olislagers wrote:
On 17-4-2012 10:36, Reinier Olislagers wrote:
In sqldb, this:
type TSchemaType = (stNoSchema, stTables, stSysTables, stProcedures,
stColumns, stProcedureParams, stIndexes, stPackages);
is used in the GetSchemaInfoSQL function:
I noticed stIndex
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
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
Very helpful, thanks Laco.
Regards,
ReinierOn 18-04-12 08: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 ('TABLE')
(in FPC (for IBCo
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 ('TABLE')
So difference with FPC: the names (catalog_name, s
On Thu, 19 Apr 2012, Reinier Olislagers wrote:
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 ('TABLE')
So differen
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 ('TABLE')
So d
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 also PRIMARY KEYs and UNIQUE constraints)
>
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
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 ('TABLE')
So d
On 19-4-2012 13:28, LacaK wrote:
> 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: Cat
> 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 * from
> INFORMATION_SCHEM
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
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 *
>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 currently not implemented: keep it that way (or drop it) but
add and implement stTableConstraints, stReferential
19 matches
Mail list logo