Board index » delphi » blank parameter to Sybase query (error)

blank parameter to Sybase query (error)

Delphi  1

A current aplication written in delphi is being converted to a Sybase
backend
using ODBC, when an edit field has no data and is being used as a
paramater
to an insert query an error occurs '..percision of char field can not be
zero'.

As you can understand I do not like the thought of changing all the
insert
statements to insert a null if the edit is blank, has anyone got a
better solution
to this problem or has someone else come across this situation.

Any help at all would be appreciated

Thank You

Adam Sorati
ad...@sgen.com.au

 

Re:blank parameter to Sybase query (error)


Have you considered modifiying the table definition on the server to allow
default spaces in the problem column?

Adam Sorati <ad...@sgen.com.au> wrote in article
<3494780D.74F91...@sgen.com.au>...

Quote
> Delphi  1

 '..percision of char field can not be
Quote
> zero'.

Other Threads