Member Avatar for dimalta

Hello,

I must modify an application build with MySQL to make it work with other databases.

This application works perfectly but use quotes in all the requests even for numeric columns.

For example:

SELECT * FROM table WHERE id='1'

(where id is declared as INTEGER)

Do you know if this syntax is accepted by all the databases?

  • 2 Contributors
  • 1 Reply
  • 42 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Grn Xtrm
Member Avatar for Grn Xtrm

MS Access doesn't use quotes around numbers. Not sure about Oracle.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.