Zeoslib Portal

usign the following Query in ZQuery

'select * from params'

where params is a table in my database, ends up in a range check error

same query on SQL works like a charm

getting there,
step by step

although your hint was vague, it helped me out with some desk research :D here's what I wrote: procedure TSNWLSQLClientMainForm.GetDBInfo; var i: Integer; TempStringList: TStringList; NameCollumn, SizeCollumn, MaxSizeCollumn, StatusCollumn: Integer; DBStatus: ShortString; ExitRepeat: Boolean; begin ...

i tried to do so,
unfortunatley Delphi help is not very helpfull with these specific componetns..

pls ignore..

might have missed smthn with copying, or caused by a second instance of delphi running...

thnx mate

nvm,
solved by using an sql query instead

was just wanting to abuse ZConnecting gettablenames as a quick and dirty resolution

but it seems to list all tables from all db's..

not jsut the tables from a single db

how is fields defined? coz I seem to only find values from the first row? (run sphelp_db database on your own sql) I am also looking for the collumn name say results look smthn like this [ ][name ][size ][max size] 1 sgmsdb 500MB unlimites 2 sgmsdb_log 100 MB 2 GB as I am unsure what collumn I am lo...

gents, I need some help understanding ZQuery, goal: Query: sp_helpdb sgmsdb from ZQuery itself (so not via a dbgrid) I am trying to: 1) from the sgmsdb database itself get size and maxsize 2) from the associated transaction log get size and max size if I peform this query in SQL itself I get a nice ...

Is ti just me,

or does GetTableNames ignore the Database property? and just lists ALL ?

I jsut downloaded 6.6.3,

when trying to compile ZComponent, it says
Required Package vclactnband not found???

usign MSSQL

once I get that working mysql is next.
will have a look at the TZDBLibConnetion

yay,

works


I was close the first time I experemimented,
but I kept putting TDAtaSource in ZQuery, instead of otherway around

adding
timeout=5
to properties, does NOT seem to work
it's still sitting waiting there for quite a while, until it finally gives up...

here's what I done so far add Zconnection -set Protocol=mssql -set hostname -set username -set password -set database add TDataSource add ZQuery -set conenction to ZConnection1 -set datasource to TDataSource -set SQL (query) add DBGrid -set datasource to TDataSource ZConnection.Connect Zquery1.Open ...