DBase question

Results 1 to 2 of 2

Thread: DBase question

  1. #1
    Join Date
    Dec 1969

    Default DBase question

    yes.. unfortunately DBase... (i.e., Events.dbf)<BR>I&#039;m developing on PWS, to publish on C!S... I can connect to the DBase database and run select queries, but can&#039;t run an update query.<BR><BR>I&#039;m trying to execute:<BR>Update Events SET Title=&#039;test&#039; WHERE EventID=1<BR><BR>Simple enough, but I get a<BR>&#039;Must use an updateable query&#039; or something like that.<BR><BR>It&#039;s not file/folder permissions; I linked the file in Access and ran the same query and got the same error.<BR><BR>Any ideas, help? I&#039;ll eventually be running on C!S, so Access is out of the question. mySQL is an answer I&#039;m considering, but I want to know if I can do this with a DBase file. <BR><BR>Secondary question to DBase, what are the date delimiters?<BR>i.e., Access is SELECT field FROM table WHERE flddate=#02/11/02#;<BR> SQL is SELECT field from table WHERE flddate=&#039;02/22/02&#039;;<BR><BR>Thanks!<BR><BR>Keith

  2. #2
    Join Date
    Dec 1969

    Default RE: DBase question

    Keith<BR><BR>It might still be file/folder permissions in the sense that the IUSR account may not have the right permissions to update a file in that directory.<BR><BR>Have a butchers at:<BR><BR>http://www.learnasp.com/learn/FAQdbUpdate.asp<BR>http://support.microsoft.com/default.aspx?scid=kb;DA;q175168<BR>http://www.google.com/search?q=operation+must+use+an+updateable+query&hl =da&<BR>lr=<BR><BR>for some more help...<BR><BR>Good luck!<BR><BR>Franco

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts