Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2014-10

TFMTBCDField problem

10 messages · 4 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Chris Rempas

Hi guys!? ? I am using SQLdb with Firebird 2. I have a DECIMAL(9,5) field that SQLdb makes it?TFMTBCDField automatically. Mt problem is that i cannot save any value to the database. If i let the field with the NULL value, my record is saved fine, if i try to put any value and save the record, it fails with "Invalid Variant convertion" error.????I Edited the record with an external tool and it loads up fine in my grid. In my grid i can change the data and scroll to another records (cached data is fine) but if i try to execute ApplyUpdates, i get the same error. ? ? Google could not help and i could not find anything in the bugtracker for the last 3 days!

Please help!!!
Regards,
Chris????
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20141022/ba744c0b/attachment.html>

Reply by email

Joost van der Sluis
to Chris Rempas
Chris Rempas wrote 13 lines
Hi guys! I am using SQLdb with Firebird 2. I have a DECIMAL(9,5) field that SQLdb makes it TFMTBCDField automatically. Mt problem is that i cannot save any value to the database. If i let the field with the NULL value, my record is saved fine, if i try to put any value and save the record, it fails with "Invalid Variant convertion" error. I Edited the record with an external tool and it loads up fine in my grid. In my grid i can change the data and scroll to another records (cached data is fine) but if i try to execute ApplyUpdates, i get the same error. Google could not help and i could not find anything in the bugtracker for the last 3 days!

If you are using fpc 2.6.4, could you try 2.7.1? (A development snapshot)?

Joost.

Reply by email

Chris Rempas
to Joost van der Sluis

Hi,? I downloaded trunk fpc but i can't get it to work, is there an easy way to get fpc 2.7.1 compiled for lazarus? Thanks
Chris

On Thursday, October 23, 2014 4:03 PM, Joost van der Sluis wrote:

Chris Rempas wrote 13 lines
Hi guys! ? ? ? I am using SQLdb with Firebird 2. I have a DECIMAL(9,5) field that SQLdb makes it TFMTBCDField automatically. Mt problem is that i cannot save any value to the database. If i let the field with the NULL value, my record is saved fine, if i try to put any value and save the record, it fails with "Invalid Variant convertion" error. ? ? ? I Edited the record with an external tool and it loads up fine in my grid. In my grid i can change the data and scroll to another records (cached data is fine) but if i try to execute ApplyUpdates, i get the same error. ? ? ? Google could not help and i could not find anything in the bugtracker for the last 3 days!

If you are using fpc 2.6.4, could you try 2.7.1? (A development snapshot)?

Joost.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20141024/06260f99/attachment-0001.html>

Reply by email

Joost van der Sluis
to Chris Rempas
Chris Rempas wrote
I downloaded trunk fpc but i can't get it to work, is there an easy way to get fpc 2.7.1 compiled for lazarus?

Hmm, it was always available at the snapshot-page
http://www.hu.freepascal.org/lazarus/ but it's not there.

Maybe that the 2.7.1 snapshot is not build anymore. But coincidentally I made a change in fpc 2.7.1 yesterday that broke building fpc on Windows.

And I received a warning from Vincent that building the snapshot failed.

So I know for sure that these snapshots are still being build. Maybe you have just bad luck that it is not available today, due to a mistake from me. So maybe wait one day, or that someone else can point out where the snapshot (from a day earlier) can be found.

Joost.

Reply by email

Chris Rempas
to Joost van der Sluis

This is killing me! i just want my headache to stop! Thanks for the responce,I will check for the updates? Chris

On Friday, October 24, 2014 2:29 PM, Joost van der Sluis wrote:

Chris Rempas wrote
? ? I downloaded trunk fpc but i can't get it to work, is there an easy way to get fpc 2.7.1 compiled for lazarus?

Hmm, it was always available at the snapshot-page
http://www.hu.freepascal.org/lazarus/ but it's not there.

Maybe that the 2.7.1 snapshot is not build anymore. But coincidentally I made a change in fpc 2.7.1 yesterday that broke building fpc on Windows.

And I received a warning from Vincent that building the snapshot failed.

So I know for sure that these snapshots are still being build. Maybe you have just bad luck that it is not available today, due to a mistake from me. So maybe wait one day, or that someone else can point out where the snapshot (from a day earlier) can be found.

Joost.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20141024/d63868d6/attachment.html>

Reply by email

Vincent Snijders
to Joost van der Sluis: Hmm, it was always available at the snapshot-page http://www.hu.freepascal.org/lazarus/…

2014-10-24 13:28 GMT+02:00 Joost van der Sluis :

Show quoted text 8 lines
And I received a warning from Vincent that building the snapshot failed. So I know for sure that these snapshots are still being build. Maybe you have just bad luck that it is not available today, due to a mistake from me. So maybe wait one day, or that someone else can point out where the snapshot (from a day earlier) can be found.

That was not from a snapshot installer build, but from a build server which just tests compilation. It does make all, does not package and does not upload, delete old snapshots etc.

Vincent
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20141027/8788014b/attachment.html>

Reply by email

Chris Crori
to Vincent Snijders

Hi Vincent,

can you help me build lazarus with fpc 2.7.1? I downloaded fpc trunk, changed the file folders, undated the lazarus configuration, but I cannot build fpc and lazarus tells me it can?t find fpc.cfg file... the file exists!

I took a look to the changes in variants.pp and I think that all changes effect readability, tBCD cannot be converted to variant, so it can?t still be passed to SQLdb to execute ApllyUpdates

Regards
Chris

Earlier message 23 lines
From: Vincent Snijders Sent: Monday, October 27, 2014 7:31 AM To: Lazarus mailing list Subject: Re: [Lazarus] TFMTBCDField problem 2014-10-24 13:28 GMT+02:00 Joost van der Sluis : And I received a warning from Vincent that building the snapshot failed. So I know for sure that these snapshots are still being build. Maybe you have just bad luck that it is not available today, due to a mistake from me. So maybe wait one day, or that someone else can point out where the snapshot (from a day earlier) can be found. That was not from a snapshot installer build, but from a build server which just tests compilation. It does make all, does not package and does not upload, delete old snapshots etc. Vincent -------------------------------------------------------------------------------- --

Reply by email

Joost van der Sluis
to Chris Crori
Chris Crori wrote 5 lines
Hi Vincent, can you help me build lazarus with fpc 2.7.1? I downloaded fpc trunk, changed the file folders, undated the lazarus configuration, but I cannot build fpc and lazarus tells me it can?t find fpc.cfg file... the file exists!

When you have downloaded fpc 2.7.1, go to the command-line and do 'make clean all'. Make sure that the compiler-executable (ppc386.exe and fpc.exe) are in your search-path. If you are on Windows this is not always the case. (set path=%path%:c:\lazarus\fpc\2.6.4\bin\i386-win32)

Then you have to do a 'make install'. But to do so, you need administrator-rights. So make sure that you use the right-mouse button when you start your console (cmd or poweshell) and select 'run as administrator'.

If you passed this step, you have fpc installed in c:\pp. Adapt the path so that it points to this new location for the compiler-binaries. (Nore that you still need a reference to the old lazarus-fpc-location, because it also contains helper utilities like make.exe)

If you are editing the fpc.cfg file, search for the lines that start with -Fu. Those need changing.

If you want to know where to place your fpc.cfg, use ppc386.exe -vt.

Then adapt the Lazarus configuration, and you should be done.

There are also scripts that do all this for you, btw.

Joost.

Reply by email

Chris Rempas
to Joost van der Sluis

...as a last resort, i formatted an old disk, installed windows 8.1, installed lazarus, downloaded a new snapshot from freepascal site, extracted and followed instructions. I get an error (i think in fpmkunit.pp) when i execute "make clean all".i tried to execute "make install" but i get the same error Regards,Chris

On Monday, October 27, 2014 5:01 PM, Joost van der Sluis wrote:

Chris Crori wrote 5 lines
Hi Vincent, ? ? ? can you help me build lazarus with fpc 2.7.1?? I downloaded fpc trunk, changed the file folders, undated the lazarus configuration, but I cannot build fpc and lazarus tells me it can?t find fpc.cfg file... the file exists!

When you have downloaded fpc 2.7.1, go to the command-line and do 'make clean all'. Make sure that the compiler-executable (ppc386.exe and fpc.exe) are in your search-path. If you are on Windows this is not always the case. (set path=%path%:c:\lazarus\fpc\2.6.4\bin\i386-win32)

Then you have to do a 'make install'. But to do so, you need administrator-rights. So make sure that you use the right-mouse button when you start your console (cmd or poweshell) and select 'run as administrator'.

If you passed this step, you have fpc installed in c:\pp. Adapt the path so that it points to this new location for the compiler-binaries. (Nore that you still need a reference to the old lazarus-fpc-location, because it also contains helper utilities like make.exe)

If you are editing the fpc.cfg file, search for the lines that start with -Fu.? Those need changing.

If you want to know where to place your fpc.cfg, use ppc386.exe -vt.

Then adapt the Lazarus configuration, and you should be done.

There are also scripts that do all this for you, btw.

Joost.

Reply by email

Joost van der Sluis
to Chris Rempas
Chris Rempas wrote 6 lines
...as a last resort, i formatted an old disk, installed windows 8.1, installed lazarus, downloaded a new snapshot from freepascal site, extracted and followed instructions. I get an error (i think in fpmkunit.pp) when i execute "make clean all". i tried to execute "make install" but i get the same error

Can you show us the error?

Regards,

Joost.

Reply by email