Hi Guys,
I hope there are some Excel experts out there.
I need to create Excel 2000 worksheets from inside a PB App (v10.2) and I thought this would be straightforward!!!!
So read the documentation - which makes very little sense. OK let's try another tack.
Browse around this here...
PB 4 - wow? As I remember it was very stable - well 4a was.
You can use ODBC with no problems but I would reccommend OLE DB. If you use the db profile painter there is a preview tab which shows you the connection details, eg:
SQLCA.DBMS = "OLE DB"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False...
Yup,
As mbalent says there is no difference between the two in fact there are not two things here at all.
Remember you can put brackects around any exprssion you want,
so you cold say
messageBox( ls_heading, ls_text)
or
messageBox( (ls_heading), (ls_text))
these are NOT two different forms...
Yes I noticed a similar post you made some time ago.
A while ago I created a new object that was a descendant of the transaction object. In this object I placed my begin/end/test/error check code and used SQL statements as decscribed above (eg Execute Immediate "BEGIN TRANSACTION"; etc)...
Can anyone help?
I have an application that was originally written under PB7. I have now upgraded to PB10, which is infinitely more stable in the development environment - eg I can now actually use the debugger with confidence.
However, I have a really serious issue - transaction processing...
I had done all of this.
The problem was two or three fold:
1)The sybase site was telling me that my password did not match. I had written down the password and was convinced it was right - but... who knows.
I then requested a new password, which came back immediately. I entered this and got...
<<Before re-installing PB have you tried uninstalling the existing version of PB.>>
I assume you mean the PB10 version? No, I haven't bothererd but I am pretty sure it will work - its basically what I am doing by renaming the c:\program files\sybase directory when I want to run a particular...
Well you certainly can with some versions, remember this is natural with something like MS SQL Server.
In the manual for SQL Anywhere 5, there is a section (chap 28) about starting the database as an NT service and within this section it tells you how to start multiple databases.
"To start a...
No, I manually rename one of them back to \program files\sybase before I run - so I can only run one of them at a time.
I tried installing PB7 in another directory and this was fine until I applied the EBF, which wanted to put most of its files in: \program files\sybase - irregardless of where...
This may be of no use because I haven't used the Sybase db (I assume this is ASA from the prog names) for quite some time now.
But anyway.
With some earlyish versions of the db server you could open more than one database in one instance of the server - has this changed?
Bill
Hi A0C61ZZ,
Let me bring you up to date!
I uninstalled PB7 and renamed the \program files\sybase directory to \program files\sybase_10. I then reinstalled PB7 and lo and behold it worked. I then applied the final EBF for PB7 and this was all fine and dandy, I thought I had cracked it.
So I...
Is good food descended from food?
If so I am not sure you can overload a fucntion with a descendant - have to say I cannot remember ever having tried it.
I assume that you have dived in and given it a go and it told you to sod off?
Bill
Well of course you will get a blank line because the carriage return/line feed pair are not part of the test they are always included:
If(IsNull(addl_owner_name_suffix ) or Len(Trim(addl_owner_name_suffix )) = 0 ,'', ' ' + Trim(addl_owner_name_suffix) + '.') + '~r~n' +
In another line (ie one...
I am running PB7 in windows 2000 and it has compiled programs in the past OK.
BTW compilation is to machine code!
Now all of a sudden it has stopped compiling and gives the following error message:
Codegen compilation error, see file 'C:\DOCUME~1\bill\LOCALS~1\Temp\new_main.log'.
When you look...
Hi,
Question for mbalent, I hope you are still watching this.
I have now upgraded to version 10.0 - they are still not shipping 10.2.
You mention in one of your posts that we now have to use OLE DB to connect to MS SQL Server. Can you tell me what I need to do to connect via OLE DB, or point...
Thanks for the info!
From your posts can I take it that you are a MS SQL Server user too?
If so can you tell me how to access image fields please.
Bill
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.