>still gives me the record out of range error when my report is displayed here is what my code looks like
>create cursor cash;
> (buys y(5),newloans y(5))
OK; the specification for the data types is wrong, but harmlessly so - datatypes such as I, Y, D, T, L, M, P and G do not expect or need a size spacification, and will ignore it if passed.
If your report expects an index to be present and in use for the cursor, it's likely to looking for a .IDX file and finding one that matches an old version of the data file - the error "record out of range" is ordinarily associated with an out-of-sync index file. Look at the DE and check if it expects to find an index in place for the entry in the report's DE; if so, create the index file on the cursor before issuing the REPORT so that it reflects the state of the data in the cursor at report time.
>INSERT INTO cash (buys, newloans);
> VALUES (500, 500)
>browse
>select cash
>do c:\report1.frx
>if i do a browse it looks like this
>
> buys newloans
> 500.0000 500.0000
>
>this looks right but think there is somthing wrong with the report?
>
>thanks Kelly