Re: tsunami question
- Posted by "George Walters" <gwalters at sc.rr.com> Dec 17, 2003
- 489 views
nevermind. It gives this message when the file can't be found.....I forgot to prepend the path. george ----- Original Message ----- From: "George Walters" <gwalters at sc.rr.com> To: <EUforum at topica.com> Subject: Re: tsunami question > > > Next problem, I've created all the files and now am trying to open one to > populate it and am getting this long message that it's not a file created > with trm or the header is corrupted or created by a different dll version. > Any Ideas?? > > george > > ----- Original Message ----- > From: "Ron Austin" <ronaustin at alltel.net> > To: <EUforum at topica.com> > Sent: Wednesday, December 17, 2003 2:51 PM > Subject: RE: tsunami question > > > > That's interesting George, but I believe it assumes you are using the > > "String based API" and Euman used the "Pointer based API #1". > > > > I don't think there is a way of passing a filedef when creating the file > > with the pointer base api. > > > > string API: result= trmCreate(file$,FileDef$,OverWrite) > > pointer API: result= trmCreate(file,OverWrite) > > > > pointer based assumes the filedef has already been defined. > > > > Maybe Euman will have a different answer, but that's the way I see it. > > > > > > George Walters wrote: > > > > > > > > > Ron, there was some interesting code (power basic) on the TRM website on > > > this issue. > > > > > > > > > ' Open the existing Tsunami file > > > > > > MultiUser& = %FALSE > > > File$ = "C:\My Data\Customers.dat" > > > > > > hFile& = trm_Open(File$, MultiUser&) > > > > > > IF hFile& < 1 THEN > > > Msg$ = "Error opening file:" + STR$(ABS(hFile&)) > > > ' Display message > > > > > > ELSE > > > ' File opened successfully > > > ' Get it's File Definition string > > > > > > FileDef$ = trm_GetFileDef(hFile&) > > > > > > ' Close the file so it can be recreated > > > > > > Result& = trm_Close(hFile&) > > > > > > IF Result& THEN > > > Msg$ = "Error closing file:" + STR$(Result&) > > > ' Display message > > > > > > ELSE > > > ' The file is closed... we can now recreate it using the > > > ' file's original name and original File Definition string > > > > > > OverWrite& = %TRUE > > > > > > Result& = trm_Create(File$, FileDef$, OverWrite&) > > > > > > IF Result& THEN > > > Msg$ = "Error recreating file:" + STR$(Result&) > > > ' Display message > > > ELSE > > > ' File recreated successfully > > > END IF > > > > > > END IF > > > END IF > > > > > > > > > ----- Original Message ----- > > > From: "Ron Austin" <ronaustin at alltel.net> > > > To: <EUforum at topica.com> > > > Sent: Wednesday, December 17, 2003 1:26 PM > > > Subject: RE: tsunami question > > > > > > > > > > George Walters wrote: > > > > > > > > > > > > > > > Ron, I understand the Create function, but using this you have do > define > > > > > all > > > > > over again the characteristics of the file. I was hoping that a > function > > > > > existed that would simply clear the file and retain it's original > > > > > characteristics. > > > > > > > > > > george > > > > > > > > > As far as I know, there is no "clear file". I have made an "init.exw > > > > program for each of my files, for instance DiagInit.exw creates the > > > > Diagnosis.dat file. There is one line to define the file, two lines > to > > > > create the two indexes and then the final line creates (or re-creates > > > > the file). Since the init program had to be written to initally > create > > > > the file, all you have to do is run it again to clear the file, or as > I > > > > said earlier maybe it wood be good to put the procedure for creating > all > > > > the indexes in one include file and call them as needed. > > > > ClearFile("Diagnosis.dat") or even CLearFile("Diagnosis") is all you > > > > would need. Of course you would still have to be sure no one was > using > > > > the file when you cleared it. I imagine you are already doing that > with > > > > your present file system anyway. > > > > > ----- Original Message ----- > > > > > From: "Ron Austin" <ronaustin at alltel.net> > > > > > To: <EUforum at topica.com> > > > > > Sent: Wednesday, December 17, 2003 12:20 PM > > > > > Subject: RE: tsunami question > > > > > > > > > > > > > > > > George Walters wrote: > > > > > > > > > > > > > > > > > > > > > I don't see a function to clear a tsunami file w/o deleteing it > and > > > > > > > recreating it. Did I over look this? I have a lot of files that > are > > > > > > > cleared > > > > > > > at the end of the month or year as well as transaction files > that > > > need > > > > > > > to be > > > > > > > cleared after being posted. > > > > > > > > > <snip> > > > > > > TOPICA - Start your own email discussion group. FREE! > > > > > > > TOPICA - Start your own email discussion group. FREE! > >