Any tips on Linking an Array and a Random access file ?
Any tips on Linking an Array and a Random access file ?
(OP)
I'am trying to get the same kind of functionality of a Database without the overhead of the Jet engine, basicaly,
Add a new record, Edit a record and Delete a record, Add and Edit are pretty straight forward but Delete is giving me some problems; What I came up with was to copy the array into a temporary array, redimensioned minus the record to be deleted, then overwrite the Random access file with the temporary array, then copy it back into the orginal array. All though it works, it seems alittle messy. Does anyone know of a better way?
Thanks
Collin
Add a new record, Edit a record and Delete a record, Add and Edit are pretty straight forward but Delete is giving me some problems; What I came up with was to copy the array into a temporary array, redimensioned minus the record to be deleted, then overwrite the Random access file with the temporary array, then copy it back into the orginal array. All though it works, it seems alittle messy. Does anyone know of a better way?
Thanks
Collin
RE: Any tips on Linking an Array and a Random access file ?
RE: Any tips on Linking an Array and a Random access file ?
I don't use the Jet engine myself - I'm an Oracle kind of chap - but people seem to use it without much bother (except Alt255 it seems <grin>).
Re-inventing wheels is very time consuming. Have another look at Jet.
Mike
Mike Lacey
Mike_Lacey@Cargill.Com
RE: Any tips on Linking an Array and a Random access file ?
It’s true, computers have come a long way. Some of use refuse to forgive the early insults and go with the SQL flow. May be my loss, but I’m living with it quite well, thank you. :)
And Collin, for what you are trying to do, I think you're on the right track.
RE: Any tips on Linking an Array and a Random access file ?
I take it all back!!! LOL.
Mike.
P.S. I'm not much of a Jet fan myself - you notice that I use Oracle?
Mike Lacey
Mike_Lacey@Cargill.Com
Cargill's Corporate Web Site
RE: Any tips on Linking an Array and a Random access file ?
RE: Any tips on Linking an Array and a Random access file ?
Maybe is not what you wanted but is faster is you need to delete several records at once.
RE: Any tips on Linking an Array and a Random access file ?
RE: Any tips on Linking an Array and a Random access file ?