Re: Passing parameter from Data Environment to Oracle ?

Tech-Archive recommends: Speed Up your PC by fixing your registry

ok, I got it, I have to use Question mark ?

Select * from mytable where InvNo=?

Best Regards,

Luqman


"Luqman" <pearlsoft@xxxxxxxxxxxx> wrote in message
news:eM7ow8RlGHA.4144@xxxxxxxxxxxxxxxxxxxxxxx
What is the syntax of passing parameter to oracle from VB-6 Data
Environment
Designer.

I tried following:

Select * from mytable where InvNo=mInvNo <------ this works only with
Microsoft Access but not with oracle and sql server

I also tried putting @ before parameter name but could not succeed.
Select * from mytable where InvNo=@mInvNo


The parameter name is not listing in Data Environment Parameter Tab.

Any idea please ?

Best Regards,

Luqman






.

Relevant Pages

  • ORACLE DBA -- Western Suburbs of Chicago
    ... OPERATIONAL ORACLE DBA ... DBA will work in the Oracle environment and help manage a complex ... with many constituencies to develop database solutions to business ... with a minimum of 3 years' of Oracle DBA experience. ...
    (comp.lang.python)
  • SUMMARY: Solaris 10 zone - user processes crashing randomly
    ... When talking to Oracle the ... I am in a Solaris 10 environment. ... or similar user processes crashed again. ... According to some core-files it ...
    (SunManagers)
  • Compiling Multiple versions of DBD::Oracle
    ... supporting a large Solaris Environment. ... I need to compile a set of DBI/DBD::Oracle modules such that they are able ... revision' oracle environment would be backward compatible, ... may not have a C compiler in my production environments, ...
    (perl.dbi.users)
  • Re: gc quiesce
    ... instance RAC environment hosted on Microsoft Windows 2003 Server (x64 ... Any idea what causes this random 'gc quiesce' event blocks? ... In RAC context, GC quiesce probably means to quiesce a resource DB. ... Oracle Corp. and work with them. ...
    (comp.databases.oracle.server)
  • Oracle Apps Dba, Financial, Dallas, Texas..Contract to hire.
    ... Procurement and stand alone Oracle RDBMS ... Oracle applications include G/L, A/P, ... upgrading the current applications environment and stand alone RDBMS to ... application client/server tiers, etc.). ...
    (comp.databases.oracle.marketplace)