FiveTech Software tech support forums

... issue I have had sporadically and have no clue where to begin to look. I have an application that is just a simple update of a database with two relational databases...typically have about 15 users at a time. Inexplicably, the main database will replicate itself many times over...this used to ...

... is limited to editing existing records and adding or editing related records spun off with a seperate recordset SELECT * ( or fields ) from <relational table> where <condition> = <primary key> .. returns only a cursor with limited records and I might add with no INDEXES... ...

... about indexes .. or TAGS .. generally speaking I was creating the ORDER by in the SQL statement as to how I want to see the records and on the relational tables .. opening a recordset with the sql clause .. WHERE ASSOCIATED_FILE_NUM ='"+cFILENUM+"'"+" order by date_" .. not even using an index. ...

... ) IF oRs:eof() Msginfo( "File Number "+cFind+" can not bre found" ) oRs:MoveFirst() ENDIF ENDIF //------------------------------ // update all the relational tables cID := STR( oRs:Fields( "id" ):Value) cNAME := oRs:Fields( "FILE_NAME" ):Value cFILE := oRs:Fields( "FILE_NUM" ):Value oCn := CREATEOBJECT( ...

Enrico I think I came to that same conclusion .. many relational tables .. just apply insert updates to each instead of combining them all into one join .. I can tell you .. this exersize has been a valuable lesson .. but thinking down the road .. I ...

Rick Lipkin wrote:Looking for that magic INSERT sql statement and the connection string to update all the matching relational records and tables.

I think you have to issue several INSERT statement.

EMG

Enrico Sounds complicated .. but not really .. that Access table I sent you had prob 6 more relational tables .. and they are all joined by the primary\foreign key of File_num. This little application is an effort at cleaning up this data and instead of using file_num ...

Hello, A dentist asked me to explore te possibilities to write a dental program. Normaly a relational database is not a problem. But a dental program has something specific. They start from a map with teeth. They click on one tooth and there comes a graph with that thoot ...

Ehab,

Usually you may need to use "one to many" relational DBFs, unless you want to store everything into a memo field.

You may review samples\gallery\onemany.prg

... on the server. This typically applies to some so-called "ISAM style", or "record oriented" multiuser database applications, not to a client/server relational system like SQL Server. CAUSE If a multiuser or single user database application accesses a common data store on a Windows NT file server ...