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 strongm 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. jdesign

    Returning a varchar from my proc

    you can return int value from SP only
  2. jdesign

    SELECT LOCAL VARIABLE(s)

    In my opinion nothing compares with MS SQL speed. I have copied about 1.5 milion (!!!) records with SP in... 30 seconds! this is not a joke... but good written SP. by the way - show me such trick on pervasive. I'd like to know how to optimize it's speed. My idea wasn't to prove which is the...
  3. jdesign

    pervasive and linux and 2 processors

    hello, the problem is that I have linux machine with 2 processor support. Is pervasive able to use it power? thank you J.
  4. jdesign

    SELECT LOCAL VARIABLE(s)

    ok, as I know SP are much faster that traditional select because SP are stored on server and need no being parsed everytime one execute them. if this is not true why there are SP on pervasive sql platform? ;-) besides I need to do a lot of things not only one statement so I choose SP :-)...
  5. jdesign

    SELECT LOCAL VARIABLE(s)

    yes, I am using stored procedure! create procedure MyProc() as begin -- this is a sample only not real problem declare :myCustomerName varchar(30); declare :myCustomerUID varchar(30); declare :myCustomerPrice decimal(19,0); -- I want to initialize all this variables in ONE...
  6. jdesign

    SELECT LOCAL VARIABLE(s)

    surely I've forgot to show you my pervasive code: -- do something... SELECT :myCustomersName = CustomersName FROM Customers WHERE SecPolID = 3233 -- ok, here goes another fragment of code...
  7. jdesign

    SELECT LOCAL VARIABLE(s)

    hello guys, is this possible to use SELECT statement to initialize local variable. MS SQL supports such kind of operation: SELECT @myCustomersName = CustomersName FROM Customers WHERE SecPolID = 3233 when I try to use this in pervasive I got Syntax Error: SELECT ?<< ??? >>=CustomersName FROM...

Part and Inventory Search

Back
Top