Zeoslib Portal

jeremicm

I have test table with 2 varchar fields and 2 text fields, in mysql 5.5 and in mysql 4.1.9. On both servers i have same problem. On a form i put 4 labelededits and copy/paste same text in them, "рузвям ЗЩУЬИ" (some random russian characters...)... In database, results are correct, all fiel...

jeremicm

it work now, but i had to remove

{$IFDEF DELPHI16_UP}Winapi.{$ENDIF} declaraton from ZDbcAdoResultSet.pas (can't find winapi.dcu file)
and
<main_icon> xml tag from ZParseSQL.dproj file (had same icon error on parsesql project)...

jeremicm

Still don't work... I got latest svn (947) and it's same...
zcore.res file is deleted every time i try to build package and error is raised about that icon...

here's screenshot of build log...

http://imageshack.us/photo/my-images/545/greska.png/

jeremicm

ok, this is very strange... i downloaded rev 943 and tried to install Delphi16 packages... When i try to build zcore, zcore.res file dissapear from package folder, 3 ico files appear in package folder and i get compiler error [BRCC32 Error] ZCore.vrc(59): file not found: ZCore_Icon2.ico also, zcore....

jeremicm

XE2 is here, with 64b compiler... anyone tried to install zeos on new rad studio yet?

jeremicm

Also instead of

Code: Select all

where ID_CLIENT='''+select_idM+'''

use

Code: Select all

where ID_CLIENT= :ClientID
frmsetting.qryList.ParamByName('ClientID').Value := select_idM;

jeremicm

ntdll.dll gets damaged very often.... reinstall XP and all your problem should be solved....

jeremicm

varchar(1000) holds only 1000 bytes, not 1000 characters... try using varchar(max) instead....

jeremicm

Sorry, but i can't understand your question very well, but i think you wan't to see values of parameters instead of :paramname... if so, use ZSQLMonitor component and look at logs component create....

jeremicm

from time to time, there's a few spam messages on forum... latest are
http://zeos.firmos.at/viewtopic.php?p=13234#13234 and http://zeos.firmos.at/viewtopic.php?p=13235#13235..

Is there a button to report this somewhere?

jeremicm

are you sure that select is problem? i often get that error on some longint calculations on my app start... sometimes it raises error, sometimes it's fine...

jeremicm

Code: Select all

zquery.SQL.Add('SELECT * ')
zquery.SQL.Add('FROM production ');
zquery.SQL.Add('LIMIT :param1');
zquery.ParamByName('param1').Value := 100;

try this?

jeremicm

You can always do SHOW CREATE TABLE tblname (for mysql, or similar for database you use) and parse result for column you need...

jeremicm

ZQuery.Fields[].DataType should do it...

jeremicm

I don't think you can connect to .db file directly on remote server...

Zeoslib Portal

Search found 61 matches

UTF problem with Text fields (mysql)

Strange problem installing 943 on DelphiXE2

Zeos on XE2?

spam button??