Tim

I may well regret this but I thought ElevateDB was going to issue an exception when you tried to assign a string longer than a varchar field? As of b2 it isn't (eg 100 characters to a VARCHAR(50) is trincated to 50)..

Personally I think this is the right way but from an earlier thread

Message-ID: <D8EF3EFA-CA17-496B-BBA7-0FBEB2B3C7BC@news.elevatesoft.com>

you indicated it wasn't.

I've tested in both SQL & Delphi

Roy Lambert

Roy,

<< I may well regret this but I thought ElevateDB was going to issue an
exception when you tried to assign a string longer than a varchar field? As
of b2 it isn't (eg 100 characters to a VARCHAR(50) is trincated to 50).. >>

What type of SQL statement are you using - INSERT or UPDATE ?

Delphi code won't issue an exception because the common TField code
truncates the length prior to the data getting to the ElevateDB engine.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


UPDATE, and I remembered about the TDataset thing after I'd posted. It was in the original thread.

Roy Lambert

Roy,

<< UPDATE, and I remembered about the TDataset thing after I'd posted. It
was in the original thread. >>

Yep, it got turned off somehow.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


I should have kept quiet and just hoped

Roy Lambert