|
Home > Archive > Getting Started with dBASE > January 2006 > "Type" changes
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Forrest Ganther 2006-01-10, 8:23 pm |
| I have a 16 character field (containing all numbers) in a table.
When I save the value of that field to a variable, the
variable type is 'unknown'
as a result I don't get a match when later I want to return to
that rowset.
How can I get it to remain a character? or what?
thanks for any/all help
Forrest
| |
|
| >I have a 16 character field (containing all numbers) in a table.
> When I save the value of that field to a variable, the
> variable type is 'unknown'
If you are using a Local memory variable then you need to use a Private
variable to get a type of character.
| |
| John Marshall 2006-01-11, 1:23 pm |
|
Why not just use a char(mVar) when seeking. Remember however that you might need to pad the right side with blanks to fill out the entire field length.
substr(char(mVar) + space(16),1,16)
JM
Forrest Ganther Wrote:
> I have a 16 character field (containing all numbers) in a table.
> When I save the value of that field to a variable, the
> variable type is 'unknown'
>
> as a result I don't get a match when later I want to return to
> that rowset.
>
> How can I get it to remain a character? or what?
>
> thanks for any/all help
>
> Forrest
>
>
| |
| Forrest Ganther 2006-01-11, 1:23 pm |
| Thanks for the help!, I got it going now!!
"John Marshall" <john. marshall@mainstreetp
rinceton.com> wrote in message
news:8ltUAktFGHA.1080@news-server...
>
> Why not just use a char(mVar) when seeking. Remember however that you
> might need to pad the right side with blanks to fill out the entire field
> length.
>
> substr(char(mVar) + space(16),1,16)
>
> JM
>
>
>
> Forrest Ganther Wrote:
>
>
|
|
|
|
|