从VB.NET中删除dbf记录 [英] Deleting dbf records from VB.NET

问题描述

您好，


我有一个DBF表，连接正常，可以选择必要的记录和

填入数据集，

但是不能删除和更新它们，任何人都可以帮我解决怎么办

这个/


提前感谢，

Adriano

Hello,

I have a DBF table, connection is okay, can select necessary records and
fill into dataset,
but can''t delete and update them, can anyone please help me on how to do
this/

thanks in advance,
Adriano

推荐答案

当你说你不能删除时，你的意思是什么？例如，你有没有写bb命令和字段没有删除，你需要帮助

编写命令，还是你在寻找GUI工具工作和他们

不是吗？如果你能告诉我更多的情况，我可以更多的帮助（我希望;-P）

" Adriano" <广告***** @ mail.ru>在消息中写道

新闻：OG ************* @ TK2MSFTNGP14.phx.gbl ...

When you say you can''t delete, what do you mean? For instance, have you
written the commands and the fields aren''t deleting, do you need help
writing the commands, or are you looking for the GUI tools to work and they
aren''t? If you can tell me a little more abou tyour situation, I can be of
more help (I hope ;-P)
"Adriano" <ad*****@mail.ru> wrote in message
news:OG*************@TK2MSFTNGP14.phx.gbl...

你好，

我有一个DBF表，连接没问题，可以选择必要的记录和
填入数据集，
但不能删除和更新它们，任何人都可以帮我解决怎么做
这/ / /
提前致谢，
Adriano

Hello,

I have a DBF table, connection is okay, can select necessary records and
fill into dataset,
but can''t delete and update them, can anyone please help me on how to do
this/

thanks in advance,
Adriano

Hello Ryan，


感谢您的回复，

我不是在寻找用于删除的GUI工具，我只想要我的vb.net DELETE

查询到工作。当我执行以下查询时：

cmd.CommandText =" DELETE FROM`310705` WHERE SAN ='''25107''


there''s没有错误消息，似乎没问题，但实际上包含SAN的行=

''25107''未被删除。 SELECT和INSERT语句工作正常。


我有ODBC连接和dataadapter。


问候，

Adriano

WG Ryan eMVP <无线********* @ gmail.com> ó???Yéì/ó???Yéìá×??×？ó??è
$ b $bóì????Y ??：news：O1 *********** ** @ TK2MSFTNGP15.phx.gbl ...

Hello Ryan,

thanks for your reply,
I''m not looking for GUI tools for deleting, I just want my vb.net DELETE
query to work. When I execute the following query:
cmd.CommandText = "DELETE FROM `310705` WHERE SAN = ''25107''

there''s no error message, it seems okay but actually rows containing SAN =
''25107'' is not removed. SELECT and INSERT statements work fine.

I have ODBC connection and dataadapter.

Regards,
Adriano
"W.G. Ryan eMVP" <Wi*********@gmail.com> ó???Yéì/ó???Yéìá × ??×?ó??è
óì???àY??: news:O1*************@TK2MSFTNGP15.phx.gbl...

当你说你不能删除时，你的意思是什么？例如，你有没有编写命令，字段没有删除，你需要帮助
编写命令，还是你正在寻找GUI工具来工作和
他们不是'' T？如果你能告诉我更多的情况，我可以提供更多的帮助（我希望;-P）
阿德里亚诺 <广告***** @ mail.ru>在消息中写道
新闻：OG ************* @ TK2MSFTNGP14.phx.gbl ...

When you say you can''t delete, what do you mean? For instance, have you
written the commands and the fields aren''t deleting, do you need help
writing the commands, or are you looking for the GUI tools to work and
they aren''t? If you can tell me a little more abou tyour situation, I can
be of more help (I hope ;-P)
"Adriano" <ad*****@mail.ru> wrote in message
news:OG*************@TK2MSFTNGP14.phx.gbl...

你好，

我有一个DBF表，连接没问题，可以选择必要的记录和
填入数据集，
但是不能删除和更新它们，任何人都可以帮我解决怎么办
这个/

提前感谢，
Adriano

Hello,

I have a DBF table, connection is okay, can select necessary records and
fill into dataset,
but can''t delete and update them, can anyone please help me on how to do
this/

thanks in advance,
Adriano

不要把表名放在''''

cmd.CommandText =" DELETE FROM 310705 WHERE SAN =''25107''"

肯

--------------


" Adriano" <广告***** @ mail.ru>在消息中写道

新闻：uB ************** @ TK2MSFTNGP10.phx.gbl ...

Hi,

Dont put the tablename in '' ''

cmd.CommandText = "DELETE FROM 310705 WHERE SAN = ''25107''"
Ken
--------------

"Adriano" <ad*****@mail.ru> wrote in message
news:uB**************@TK2MSFTNGP10.phx.gbl...

Hello Ryan，我不是在寻找用于删除的GUI工具，我只想让我的vb.net DELETE
查询工作。当我执行以下查询时：
cmd.CommandText =" DELETE FROM`310705` WHERE SAN =''25107''

没有错误信息，似乎没关系，但是实际上包含SAN =
''25107''的行不会被删除。 SELECT和INSERT语句工作正常。

我有ODBC连接和dataadapter。

问候，
Adriano

" W.G。 Ryan eMVP <无线********* @ gmail.com> ó???Yéì/ó???Yéìá×??×？ó??è
óì????Y ??：新闻：O1 ************* @ TK2MSFTNGP15 .phx.gbl ...

Hello Ryan,

thanks for your reply,
I''m not looking for GUI tools for deleting, I just want my vb.net DELETE
query to work. When I execute the following query:
cmd.CommandText = "DELETE FROM `310705` WHERE SAN = ''25107''

there''s no error message, it seems okay but actually rows containing SAN =
''25107'' is not removed. SELECT and INSERT statements work fine.

I have ODBC connection and dataadapter.

Regards,
Adriano
"W.G. Ryan eMVP" <Wi*********@gmail.com> ó???Yéì/ó???Yéìá × ??×?ó??è
óì???àY??: news:O1*************@TK2MSFTNGP15.phx.gbl...

当你说你不能删除时，你的意思是什么？例如，你有没有编写命令，字段没有删除，你需要帮助
编写命令，还是你正在寻找GUI工具来工作和
他们不是'' T？如果你能告诉我更多的情况，我可以提供更多帮助（我希望;-P）
阿德里亚诺 <广告***** @ mail.ru>在消息中写道
新闻：OG ************* @ TK2MSFTNGP14.phx.gbl ...

When you say you can''t delete, what do you mean? For instance, have you
written the commands and the fields aren''t deleting, do you need help
writing the commands, or are you looking for the GUI tools to work and
they aren''t? If you can tell me a little more abou tyour situation, I
can be of more help (I hope ;-P)
"Adriano" <ad*****@mail.ru> wrote in message
news:OG*************@TK2MSFTNGP14.phx.gbl...

你好，

我有一个DBF表，连接没问题，可以选择必要的记录和
填入数据集，
但是不能删除和更新它们，任何人都可以帮我解决怎么办
这个/

提前感谢，
Adriano

Hello,

I have a DBF table, connection is okay, can select necessary records and
fill into dataset,
but can''t delete and update them, can anyone please help me on how to do
this/

thanks in advance,
Adriano

这篇关于从VB.NET中删除dbf记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！