Home
Top.Mail.Ru Yandeks.Metrika
Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Down

Help! I do Select * From T1 -> refresh -> error (ADODataSet) Find similar branches


nic406   (2001-11-28 04:21) [0]

1. In ADODataSet (CommandText) I set Select * from T1. On the form
TDataSource, ADODataSet and GRID are related. -> Dset.Open -> information in Gride (Ok!). deleting the record is normal. I do Dset.Refresh -> osh. "Insufficient key column information for refreshing" -> what's the matter?
2. Help make the Stored Procedure (SQL2000) for Select, running on the Server and allowing you to - search, sort (2,3 column) and how to start from Delphi5 (ADO) - which type of cursor is better to use and how to bind parameters. Selection by 1 record is not interesting -> Grid filling is required
Thank you in advance for your help. New to SQLServer.
My E: mail kivc406@mail.ru



Flagman   (2001-11-29 07:21) [1]

Or maybe try not refresh, but requery?



Polevi   (2001-11-29 08:12) [2]

1. Primary key is needed in the table



amamed_3071   (2001-11-29 08:59) [3]

Dset.Refresh REPLACE FOR REQUERY TO FROM adoquery1.requery



nic406   (2001-12-04 07:06) [4]

Thanks a lot!



Pages: 1 whole branch

Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Top









Memory: 0.82 MB
Time: 0.041 c
14-22355
frostbite
2001-11-06 12:39
2002.01.08
Translation


14-22385
moderator
2001-11-03 11:57
2002.01.08
> To Merlin - (SYSTRAY)


1-22000
Striker
2001-12-13 07:59
2002.01.08
Transferring data to an Excel worksheet cell


1-22211
uuuu
2001-12-13 22:46
2002.01.08
Good evening, day, morning. People help !!! how to dial a number, switch to tone mode, and enter a random code *


14-22366
Vlados
2001-11-05 10:41
2002.01.08
Plotting





afrikaans albanian Arabic armenian azerbaijani basque belarusian bulgarian catalan Chinese (Simplified) Chinese (Traditional) croatian Czech danish Dutch English estonian filipino finnish French
galician georgian German greek haitian Creole hebrew Hindi hungarian icelandic indonesian Irish italian japanese Korean latvian lithuanian macedonian malay maltese norwegian
persian polish portuguese Romanian russian serbian slovak Slovenian Español swahili Swedish thai turkish Ukrainian urdu vietnamese welsh yiddish bengali bosnian
cebuano Esperanto gujarati hausa hmong igbo javanese kannada khmer lao latin maori marathi mongolian nepali punjabi somali tamil telugu yoruba
zulu
English French German Italian Portuguese Russian Spanish