Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hilbrink

    Cast

    The situation is that we have an application that runs on different database servers such as Oracle, SQL Server, Interbase. In order to communicate with these databases we use SQL. First standard SQL and translate this to the SQL dialect that is needed. Our standard SQL includes the cast...
  2. hilbrink

    Cast

    I'm using 8.0.6
  3. hilbrink

    Cast

    ...select cast(sysdate as varchar2(20)) from dual; Te error message i get is: select cast(sysdate as varchar2(20)) from dual * ORA-00905: missing keyword ?? please help (What i try to do is to cast several things (the above is just an example) but don't want to use the...
  4. hilbrink

    Dual in Interbase

    i believe there is no such thing.... :-(
  5. hilbrink

    Not a Valid Export File

    When exporting, the default values for certain parameters are operating-system specific. Specifically, the BUFFER parameter defaults to a value of 4K under Windows NT and the RECORDLENGTH parameter defaults to 2K. I don't know what these parameter defaults are for Solaris. But perhaps this has...
  6. hilbrink

    oracle, sybase,mysql?

    You can compare some databases at: http://www.mysql.com/information/crash-me.php maybe that can help you giving insight in the possibilities of the different databases.
  7. hilbrink

    Help: Interbase 6 and BDE

    What error(s) do you get?
  8. hilbrink

    Help: Interbase 6 and BDE

    Do you get an error message? (-:
  9. hilbrink

    Why this query is empty? It have

    Is the parameter a string? Looks like an integer to me, perhaps you should try using: query1.params[0].asInteger := 001; Hope this helps ::-)
  10. hilbrink

    Building MDX query

    What exactly are you trying to accomplish in the where-clause? And what do you mean with "clauses from the same dimension"? The WHERE clause is a filter that defines the conditions each row in the source tables must meet to qualify for the SELECT. Example: SELECT ...... FROM...
  11. hilbrink

    passing procedure as parameter

    Hello, Can anybody tell me how to execute a procedure that you pass as a parameter? I have: type DBproc = procedure(); procedure DBUpdateProcedure(a_procedure: DBproc); begin {statements} a_procedure; end; procedure proc_a(); begin {statements} end; Then I would like to execute...
  12. hilbrink

    Can I store Rich Text Data Vaules in oracle ? *** Urgent***

    Have you considered using the datatype BLOB (binary large object)?
  13. hilbrink

    SQL server table not responding !!

    perhaps there is procedure thant constantly updates that table or some other process that does something with the table and never ands... check for infinite loops
  14. hilbrink

    how do you create unique

    Try to make use of the uniqueidentifier datatype and NEWID function: create table test( ID uniqueidentifier NOT NULL default NEWID(), ...
  15. hilbrink

    Moving database

    Have you tried export/import?
  16. hilbrink

    DD Unique Index

    The view DBA_INDEXES contains descriptions for all indexes in the database. The field UNIQUENESS contains the status of the index: UNIQUE or NONUNIQUE hope this was wat you meant..
  17. hilbrink

    Oracle for web page

    You might consider using Oracle Portal, an easy way to create webpages which can connect to an Oracle database: http://www.oracle.com/ip/develop/ids/index.html?portal.html (not sure if this is what you want but perhaps it might be helpful :-))
  18. hilbrink

    IBQuery1.SQL.Add('select * from test1 where data>= "'+date2+'")');

    Perhaps you could try it without de double quotes around data2. Or replace the double quotes by single quotes. Not sure if it helps...
  19. hilbrink

    Query not ending correctly?!

    Oracle SQL doesn't know the keywords INNER JOIN... :-( At least the version i'm using (8.0.6) doesn't, and i doubt if other versions do. i think you have to rewrite your query.
  20. hilbrink

    empty strings

    Hi, Does anybody know a way to let Oracle treat an empty string as an empty string and not as a null value? ('' is null should be false.) Is there a setting or parameter i can use for this? For example in SQL server there is something like sp_dbcmptlevel. Thanx in advance!

Part and Inventory Search

Back
Top