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
<*> 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/