I'm having a problem with the
/151/q_alterpropertiesnumericfielddefinition.cfm:

Insert into temp_properties select ... from properties where numericdata is
not null

Returns a Numeric Value out of Range error.

I ran the same query in Access and the data looked fine to me. The largest #
was 1,964,000,000. Is that too large?

Any ideas why it might be choking?

This is on Win2K, CF5, Spectra 1.51 with the latest Spectrasource update,
datastore is on MSSQL7.

Derek

______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
------------------------------------------------------------------------------
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to