delphi programming forums mysql charset mget recursive synonimos
free ventrilo servers hosting cs javascript delay python find in list
Back Forum New

Rank: 1
1# Jump to »
icurasPost at 2011-3-11 12:17 | Show This Author's Posts Only
abstract:

At the end i realized i added 6 varchar fields.but if i make it decimal or integer it works fine. So teh varchar or blob is a problem..i have 92 varchar fields in the db.if i add another one it gives me an error in the application.Is there a restriction in mylsql..i looked around could not find any.
So any ideas? Might it be its trying to read all the fields and its to large or something?
Thanks in advanced!!


I have the weirdest thing!!! I have a query where i say select * from table where number = number.
If it finds the number the program works fine.If the number does not exist in the query it gives me an access violation. Now ive tried recreating the form and putting other components on and still no go.
So i thought well it worked before.All i did is added new fields.So i put back my old db and added teh new fields.And yes the error came back.
At the end i realized i added 6 varchar fields.but if i make it decimal or integer it works fine. So teh varchar or blob is a problem..i have 92 varchar fields in the db.if i add another one it gives me an error in the application.Is there a restriction in mylsql..i looked around could not find any.
So any ideas? Might it be its trying to read all the fields and its to large or something?
Thanks in advanced!!

TOP

Rank: 1
2#
murklysPost at 2011-3-11 12:17 | Show This Author's Posts Only
Unless your "number" is non-numeric, there should not be any problem. Maybe the error occurs when you try to access a field of an empty result. That would be normal. It is a good practice to check if the query executed and if it returned anything and only then try to access data. I don't think that the query procedure itself could give you an access violation, or does it?

TOP

Rank: 1
3#
icurasPost at 2011-3-11 12:17 | Show This Author's Posts Only
Hi.Thanks for the reply
Its the query itself..i am thinking its a delphi error.but i tried it on 2 diffrent machines..its a normal select query.with one parameter.i debugged it and as soon as it gets to the open statment it give me the violation..
but if i select all from the table and the record exist it is fine.it runs.
its just weird...if i do the query through mysqlfront, of mysql query browser it works fine!!!!iv thought i did something wrong in teh code so i run another project on the same data..teh same error!!

TOP

Rank: 1
4#
murklysPost at 2011-3-11 12:17 | Show This Author's Posts Only
Are you using odbc or something like that? I had some pretty weird stuff going on with odbc before, but unfortunately, i don't remember how i solved it. It was via odbc settings surely.

TOP

Rank: 1
5#
icurasPost at 2011-3-11 12:17 | Show This Author's Posts Only
abstract:

At the end i realized i added 6 varchar fields.but if i make it decimal or integer it works fine. So teh varchar or blob is a problem..i have 92 varchar fields in the db.if i add another one it gives me an error in the application.Is there a restriction in mylsql..i looked around could not find any.
So any ideas? Might it be its trying to read all the fields and its to large or something?
Thanks in advanced!!


Yes i am using odbc. Its the easiest way to connect. I dont really know a another way to connect to the db. I'v seen a few articals on the net but dont understand the other ways to connect!
Whats the best way?

TOP

Rank: 1
6#
murklysPost at 2011-3-11 12:17 | Show This Author's Posts Only
I think these errors occur because odbc tries to parse the query or results itself and there's a setting somewhere to make it leave the query for the server to handle.
Anyway, you could look up zeos database components and you won't need to use odbc.



At the end i realized i added 6 varchar fields.but if i make it decimal or integer it works fine. So teh varchar or blob is a problem..i have 92 varchar fields in the db.if i add another one it gives me an error in the application.Is there a restriction in mylsql..i looked around could not find any.
So any ideas? Might it be its trying to read all the fields and its to large or something?
Thanks in advanced!!

TOP

Back Forum