Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
john2236
Starting Member
3 Posts |
 Posted - 2007-02-27 : 07:04:47
|
| Hello all (:I'm making a program, when I put the auto code script to generate code for clients, citys I receive this error:Dynamic SQL ErrorSQL Error code: -206Column unknown CODCLIENTEAt line 1, column 12-----------------------------I was make a auto code for the city table, the script in the SQL statement is: select max (codcidade) as MAIOR from cidade...it's all OKBut when I do with client table I received the error above.The script is completely right, the table name is right, column name too, but I don't know what is happening ;/please someone help me and sorry, I don't speak english very well =P |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-27 : 07:12:25
|
| Well, the parser says the column CODCLIENTE does not exists. Do you have permission to SELECT from the column?Post you code here and we will have a look at it.Peter LarssonHelsingborg, Sweden |
 |
|
|
john2236
Starting Member
3 Posts |
Posted - 2007-02-27 : 07:18:24
|
| /* Table: CLIENTE, Owner: SYSDBA */CREATE TABLE "CLIENTE" ( "codcliente" INTEGER NOT NULL, "nomecliente" VARCHAR(60), "codcidade" INTEGER, "telefone" VARCHAR(11), "endereco" VARCHAR(80), "comentarios" VARCHAR(300), "devedor" FLOAT, "expiraem" DATE, "comprasfeitas" INTEGER,CONSTRAINT "PK_CLIENTE" PRIMARY KEY ("codcliente"));this code? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-27 : 07:24:00
|
| This is not Microsoft T-SQL, right?What DBMS are you using? DB2? MySQL?Peter LarssonHelsingborg, Sweden |
|
|
|
john2236
Starting Member
3 Posts |
Posted - 2007-02-27 : 07:25:47
|
| I'm not sure about it..I'm using IBOconsole to create databases with firebird 1.5 server...and programming in Delphi 7. |
|
|
|
|
|
|
|
|
Auto code - help