Search results for query: *

Forms are discussed in Oracle: Enterprise Developer Suite, but that's usually a pretty quiet forum. Jim oracle, vb

Right before the execute statement, put in msgbox that displays SQL, and see if you can spot an error in the string. Also check if SQL is reserved. Jim oracle, vb

Isn't it just len(the_string)? Jim oracle, vb

OK, forget my first suggestion. The error message seems to be indicating that "Test" is read only. Can you verify that? Can you write a short routine that opens up Test, reads it, and attempts to update it? Use debug and highlight the various variables to see their values, if...

if all else fails, find code for a daemon that will listen for commands via a pipe. You can find code like that on the internet, or in oracle's book on your version of oracle. In the stored procedure, pipe the command to the daemon, which will execute it. Well, in unix it's called a daemon, in...

Try moving the addnew outside of the Do section, so that it is a stand-alone command. Jim oracle, vb

try sys.dba_tab_columns Jim oracle, vb

try host Jim oracle, vb

Although in an insert method, order by is not needed... Jim oracle, vb

Which line in the module does debug highlight? Jim oracle, vb

I don't remember for sure, but don't you have to provide a break or some such statement to keep the case statement from continuing on to to the next choice? Jim oracle, vb

Note that depending upon your sequence buffer setting, among others, that you may experience some gaps in your sequence(s). The buffer gets some number of sequences, say 10 or 20, but if they're not used in some period of time, the remaining are tossed and the sequence starts again at a higher...

Isn't there a way to convert a long to a varchar2, assuming the long isn't over 32k or whatever the current limit is? You could then convert the varchar2 to a number. Jim oracle, vb

There's a book something like XML and Oracle that shows how to generate XML using Oracle commands. I'll take a look at the title tonight if you can't locate it. Jim oracle, vb

is your exe multi-thread? Jim oracle, vb

Test it first, but if you are using embedded sql then Delete from Orderinfo where Orderinfo.ID not in (select Iteminfo.ID from Iteminfo) will delete the entire set of records. If you only want to clear the id in Orderinfo, use an update statement, instead. Jim oracle, vb

first, to get only the records that have 'duplicates' in your select statement add having count(*) > 1 before your group by statement second, in Oracle sql*plus you can define columns, and you can define something like levels, sorry it's been too long, so that your report would...

or, just delete from Board; ( as long as you don't have a where clause, all records will be deleted ) Jim oracle, vb

By the way, in Oracle you can order by some column(s) you don't select. Jim oracle, vb

There were some dbstart scripts that didn't work correctly; I think it had to do with the version (of Oracle) checking that they did. Make a copy of the script and either take out the checking or review/ modify it, or just hardcode your version in everyplace that a version is asked for. Jim...