|
| upper or lower case in select |
 |
Fri, 14 Mar 2008 17:40:31 -030 |
dbi 2.61 / interbase 6.01
have any properties to indicate upper or lower in select ?
example:
select n_number,n_name from table1
or
select N_NUMBER,N_NAME from TABLE1
I have 2 computers, and one program, in one this, the select with lower
case are good, but the same program in another computer, only is ok with
upper case !
TIA
Artur Sanfins
|
| Post Reply
|
| Re: upper or lower case in select |
 |
Sat, 15 Mar 2008 00:35:42 -040 |
In article <S32i1ZhhIHA.940@news-server>, artur.dbase1@tcimix.com
says...
> dbi 2.61 / interbase 6.01
> have any properties to indicate upper or lower in select ?
> example:
> select n_number,n_name from table1
> or
> select N_NUMBER,N_NAME from TABLE1
>
> I have 2 computers, and one program, in one this, the select with lower
> case are good, but the same program in another computer, only is ok with
> upper case !
>
> TIA
>
> Artur Sanfins
Artur,
I would suspect your ODBC settings are not the same on both machines.
Compare them carefully. I know Firebird has a "Sensitive Identifier"
setting. InterBase likely has something like that, too.
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada
.|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
|
| Post Reply
|
| Re: upper or lower case in select |
 |
Mon, 17 Mar 2008 10:52:05 -030 |
I found the difference in configuration/drivers/natives/intrbase, SQLDIALECT
where in one machines has 3 and another nothing as default.
After alter to same default, the program run ok !
Tankyou
Artur Sanfins
> Artur,
>
> I would suspect your ODBC settings are not the same on both machines.
> Compare them carefully. I know Firebird has a "Sensitive
Identifier"
> setting. InterBase likely has something like that, too.
>
> --
> Geoff Wass [dBVIPS]
> Montréal, Québec, Canada
>
> .|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
> .|.|.| ---------------------------------------------------------- |.|.|.
> .|.|.| IT Consultant http://Geoff_Wass.com |.|.|.
|
| Post Reply
|
| Re: upper or lower case in select |
 |
Tue, 18 Mar 2008 01:21:47 -040 |
In article <oudwhjDiIHA.1880@news-server>, artur.dbase1@tcimix.com
says...
> I found the difference in configuration/drivers/natives/intrbase,
SQLDIALECT
> where in one machines has 3 and another nothing as default.
> After alter to same default, the program run ok !
> Tankyou
>
> Artur Sanfins
Artur,
That's great to hear! Thanks for the success report.
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada
.|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
|
| Post Reply
|
|
|
|
|
|
|
|
|
|