Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

One to Many List

Status
Not open for further replies.

SMCmtg

Programmer
Mar 27, 2000
90
US
We are using a &quot;one to many&quot; list on a form, in &quot;Natural Order&quot;. . .We need to &quot;insert&quot; a record into the many list, not just 'add' a new record, which adds the record to the natual order at the bottom.&nbsp;&nbsp;(No other order/index fills the visible requirement. . .)<br>Any recommendation or direction on how we might accomplish this. . .Appreciate any help. . .THX
 
Are you asking how to <i>physically</i> insert a record between two other records?&nbsp;&nbsp;Yikes!&nbsp;&nbsp;We'll all try to talk you out of it, but the solution, if that's what you really want to do, is:<br><br><FONT FACE=monospace>insert</font><br><br>This is not the SQL <FONT FACE=monospace>insert into</font>, but an xBase command that's been around since Rod Stewart.&nbsp;&nbsp;It inserts a blank record after the currently pointed to record, unless you include the <FONT FACE=monospace>before</font> keyword.&nbsp;&nbsp;But its ugly.<br><br>Of course, if I've misunderstood what you are trying to do, disregard this message, and erase the old <FONT FACE=monospace>insert</font> command from your memory.&nbsp;&nbsp;Please. <p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top