Binding number data variable to a column

General discussion forum about all databases other than SqlBase.
olvin

Binding number data variable to a column

Post by olvin » 14 Sep 2009, 05:08

Hello,

I'm working with TD 5.1 SP6 and a MySQL database (through ODBC).
When we try to bind a datafield or a variable with the data type "Number" into a SELECT clause to fill a column in a table (also with the data type "Number"), we have this error :
"SQL Error 104 : Attempt to fetch non-numeric data into numeric column"

e.g. of SQL query : "SELECT :frmTest.dfNum FROM SYSTABLES INTO :tbl1.colNum"

It works with TD 5.1 SP6 and a SQLBase database.

I have posted a sample.
You do not have the required permissions to view the files attached to this post.

Conrado Zavala

Re: Binding number data variable to a column

Post by Conrado Zavala » 21 Sep 2009, 11:04

Hello Olvin:

I have tested your sample application but I haven't been able to reproduce what you describe. Can you please provide the Build number you are using?

Thank You,

olvin

Re: Binding number data variable to a column

Post by olvin » 21 Sep 2009, 23:46

Hi,

The build of TD 5.1 SP6 that I use is 8873.
And I have try with TD 5.2 and there is no error anymore BUT when I click on TEST, the column of the table is empty...
So, it is also a problem with TD 5.2 ...

Conrado Zavala

Re: Binding number data variable to a column

Post by Conrado Zavala » 21 Oct 2009, 11:46

Hello Olvin:

I apologize for replying to you so late. Attached you will find a ZIP file that contains the result of the test I ran. Can you please take a look at it a confirm if this is the same output you are getting. If not, do you believe --by judging from this screenshot-- that what you reported has been already solved? I have run this test in an internal build. Once again, I apologize for my late answer.

Sincerely,
You do not have the required permissions to view the files attached to this post.

olvin

Re: Binding number data variable to a column

Post by olvin » 31 May 2010, 10:11

Hello,

Sorry for late reply but no problem anymore with TD 5.2 SP1.

Olvin

Conrado Zavala

Re: Binding number data variable to a column

Post by Conrado Zavala » 01 Jul 2010, 16:08

Good to know Olvin :) ... thank you for the feedback.

Return to “General Discussion”

Who is online

Users browsing this forum: [Applebot], [Ccbot] and 0 guests