Search found 9 matches

by BlairH
Sat Jun 05, 2004 5:19 am
Forum: Tricks 'n' Tips
Topic: MS-Word from PB with COM Interface
Replies: 62
Views: 46487

Can not seem to get the Excel example to work.

Can someone please provide a detailed list on getting the Excel Example to work.

I keep getting errors, saying that I have a error in the Pb include file, saying the the structure or interface is already declared double.

Help.

Blair
by BlairH
Sat Apr 10, 2004 5:01 pm
Forum: General Discussion
Topic: ODBC Help.
Replies: 0
Views: 963

ODBC Help.

I have a program that interfaces with my Palm. The windows side was written in VB6 with access database, on the Palm side I used NSbasic (very good). Then I have a third party software that builds the Palm conduit. This third party software uses ODBC to interface the two programs. I would like to re ...
by BlairH
Fri Apr 02, 2004 4:13 am
Forum: General Discussion
Topic: Microsoft Access Database. PreviousDatabaseRow()
Replies: 1
Views: 1247

Microsoft Access Database. PreviousDatabaseRow()

I have a small project that I am currently working on the uses a .MDB database, the forward command works fine however the previous row command does not. Is there a fix for this? I need to use a ODBC Database as I need it to interface with my Palm. Does SQLlite have a ODBC version?

Thanks Blair.
by BlairH
Mon Oct 13, 2003 7:41 pm
Forum: Feature Requests and Wishlists
Topic: Business application developer's wishlist
Replies: 9
Views: 3319

MS Excel & MS Access

I am a professional accountant and learned to program to aid my daily job fuctions, first VBA then VB6. After Microsoft said that they would no longer support VB6 I started to look for a new language and settled on PureBasic after looking at several others. A lot of my programs need to access Excel ...
by BlairH
Fri Oct 03, 2003 4:37 am
Forum: General Discussion
Topic: Install Probelm.
Replies: 2
Views: 1279

Ok it works now.

the version of PkUnzip that I was using was over writing the directorys. I got the latest version of PkUnzip all all is fine now. Upgrade to 3.79 just fine.

Thanks.
by BlairH
Fri Oct 03, 2003 3:06 am
Forum: General Discussion
Topic: Install Probelm.
Replies: 2
Views: 1279

Install Probelm.

Hello, I am having trouble installing the upgrades. My problem started when I tried to upgrade to version 3.79. Any way my normal routine is to unzip all the files into a folder that I call purebasicupgrade then run the Update tool.

The first time I tried this a got the error that the "Update ...
by BlairH
Wed Oct 01, 2003 2:15 am
Forum: General Discussion
Topic: Getting into COM
Replies: 5
Views: 2114

Com Access

Does this mean that you use Purebasic to access the com interface like Microsofts DAO or ADO? I am a database programmer and hit the road block of using ODBC and going backwards.

Blair
by BlairH
Tue Jul 29, 2003 5:09 am
Forum: Tricks 'n' Tips
Topic: Access DSNs Automatically
Replies: 6
Views: 2994

Procedure return Result.

Does the procedure return a zero if the connection is not made?

I changed my database to have a user and password then changed the code to following

Procedure Button1_Click()
Result.l
Result = Database_Command("Server=RMServer;Description=Family;DBQ=C:\test.mdb"+"UID=Blair;PWD=Blair;")
If Result ...
by BlairH
Sun Jul 27, 2003 11:53 pm
Forum: Tricks 'n' Tips
Topic: Access DSNs Automatically
Replies: 6
Views: 2994

Example of how to call function

I have tried the above examples and can not seem to get it to work. Can someone please provide the proper sintax to call the procedure.

I have inclued my code: I get an sintax error on database calling procedure.

;DNS Database Example

#Button1 = 1
#Button2 = 2
#MyWindow = 0

Declare Database ...