hi I want to know what are the 3 files which help in making database ? (SQL server)
Nigel Bachmann <[EMAIL PROTECTED]> wrote: Well you could load the table into a recordset and use seek/find to locate the record for deletion. If you were using SQL Server you could use cursors to loop throught the records but I don't think access has that sort of functionality. I would loop through the records in VB and delete the first instance you find. Julian Holt <[EMAIL PROTECTED]> wrote:Hi I am using access ----- a trawl round t'internet has revealed nothing. Looks like this is an incredibly difficult and highly unusual thing to want to do :-) Just to clarify further I have a table like this PartNo Description 111 Hello 123 Hello 456 World 123 Hello 123 Hello 123 Hello 123 Hello I want to delete the first occurrence of "123 Hello" to leave PartNo Description 111 Hello 456 World 123 Hello 123 Hello 123 Hello 123 Hello All the SQL I have tried to date would either delete all occurrences of "123 Hello" or delete all repeated occurrences to leave PartNo Description 111 Hello 123 Hello 456 World TA Julian -----Original Message----- From: m50h [mailto:[EMAIL PROTECTED] Sent: 11 May 2004 19:56 To: [EMAIL PROTECTED] Subject: [vbhelp] Re: Simple database question (I guess) Dear Julian Holt if you want to do this first of all you have to specify your database format and after specifying that then we can offer you a way for doing that. for example may be your database format be mdb(access) or text in binary or other things. Good luck Mohsen. --- In [EMAIL PROTECTED], "Julian Holt" <[EMAIL PROTECTED]> wrote: > Guys > > I have a database looking something like this, > > PartNo Description > 111 Hello > 123 Hello > 456 World > 123 Hello > > I want to detect the first occurrence of a given PartNo (say 123) and delete > the whole row from the DB > > So for example I want to delete the row "123 Hello" given the PartNo > 123 > > I guess its SQL but I am not too sure what to do > > > Any ideas? > > > Many thanks > > Julian Holt > > > [Non-text portions of this message have been removed] '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= ---------------------------------------------------------------------------- -- Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now [Non-text portions of this message have been removed] '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Yahoo! Movies - Buy advance tickets for 'Shrek 2' [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor ---------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM ---------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
