Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Type mismatch
Message
From
04/12/2001 04:56:02
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
03/12/2001 13:59:36
John Marrone
Bloodstock Research Inc.
Lexington, Kentucky, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00588841
Message ID:
00589109
Views:
20
>I have created a dbf using the create table command. I have a field I created
>as N(2). I have an var which holds the value 1 , when I do a replace RceaNumber
>with aAr(3) I get a type mismatch error. I have SET NULL ON because some fields
>that I read in from this text file are empty ie: ,,,,,, just commas no values
>for some fields. Can anybody help. Thanks for any help.

'From the text file..'. I suspect aAr(3) is character "1".
Replace RceaNumber with val(aAr(3))
then. From text file append from is much faster - if file,reccount is huge replace approach might be very slow.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform