Re: SQL statement in Perl doesn't work

Thank you for your comments. The last answer by Brian McCauley made me look again at the query result from the database. It turns out no rows were fetched indeed, so the script does work. By changing the range of records I got the results I expected in the first place, so I apparently misinterpreted the warning.

Huub
.

Relevant Pages

  • Re: Access 2000 Make Table Query Warning Box -- use currentdb.execute
    ... currentdb.execute "SQL or action queryname" ... When this query is run, and before it asks the user for the input, I get a warning message that says that the query is about to replace the table with new data, and is the user ok with that?, yes or no. ... As the database designer, I know to answer yes, and it goes through the function with no issues. ...
    (microsoft.public.access.queries)
  • Re: Cant Update Records
    ... >I've now put both tables in the same database ... You're apparently assuming either that you are the only person asking ... >when I try to edit...I get a warning that someone else has edited the record ... If you'ld care to post the SQL of the query, ...
    (microsoft.public.access.forms)
  • Re: Warn me Not
    ... Use Dirto test if the target file exists. ... Kill it before executing your query. ... I am taking a table in one database and, using a make table query, ... Deletions did not seem to eliminate the warning. ...
    (microsoft.public.access.queries)
  • Cross-product and join question
    ... I'm designing a query with DBArtisan against a Sybase database. ... I receive the following 'Warning' from DBArtisan: ...
    (comp.databases.sybase)
  • Re: Append query
    ... Yes Both Append queries run just fine if I just run them from main screen or ... I'll take out the warning. ... >> I am trying to run an Append query from VBA code. ... >> this in the same database to run a delete Query using this code and it ...
    (microsoft.public.access.formscoding)