Re: Reading Basic PDS ISAM Files - Database Discussion Boards

rmiller101-Apr-10 4:50

1-Apr-10 4:50

I haven't been able to find any documentation of the file structure, and I'd rather not go that route if possible.

An ODBC driver is exactly what I'm looking for. I have had no luck reading them with any of the Jet drivers.

I have searched online, and information on this seems to be fairly rare.

There has to be a simple solution, I'm just not seeing it!

Re: Reading Basic PDS ISAM Files

PIEBALDconsult1-Apr-10 9:35

PIEBALDconsult

1-Apr-10 9:35

I did some searching as well.

Out of curiosity... Is this a one-time copy of the data to a "better" database system? Or something you'll need to continue to do?

The best I can think of is to use that version of BASIC (I found a place from where it can be downloaded) to write a DLL with the required interface and call it from whatever language you want to use. Or maybe in the package there's a DLL you could call.

I also just took a quick look at an old (1999) ODBC book I have and nothing jumped out at me.

I'll give it some more thought after I have a nap... my brain hurts.

Re: Reading Basic PDS ISAM Files

rmiller101-Apr-10 9:42

rmiller10

1-Apr-10 9:42

Thanks for the replies

It will probably be an ongoing thing until I can convert the program that creates it to a more modern language.

I thought about doing that, too, and tried to download it yesterday, but I got an error!! What site did you find it on?

Re: Reading Basic PDS ISAM Files [modified]

PIEBALDconsult1-Apr-10 13:50

PIEBALDconsult

1-Apr-10 13:50

rmiller10 wrote:
What site

http://vetusware.com/download/Microsoft%20BASIC%20Professional%20Development%20System%207.1/?id=225[^]

I didn't try it.

Edit: I just downloaded it from there...

Edit: There is a file named ISAMIO.LI$, which I'm sure becomes ISAMIO.LIB when the product is installed -- maybe it can be accessed by P/Invoke?
After reading the README.DOC I see that there is (or might be) a TSR that has to be loaded -- I wouldn't be surprised.

modified on Thursday, April 1, 2010 9:05 PM

Re: Reading Basic PDS ISAM Files

PIEBALDconsult1-Apr-10 14:31

PIEBALDconsult

1-Apr-10 14:31

Maybe try:http://www.easysoft.com/products/data_access/odbc_isam_driver/[^]

Re: Reading Basic PDS ISAM Files

rmiller107-Apr-10 9:48

rmiller10

7-Apr-10 9:48

Maybe try:http://www.easysoft.com/products/data_access/odbc_isam_driver

Is this free?

Re: Reading Basic PDS ISAM Files

Luc Pattyn1-Apr-10 11:10

Luc Pattyn

1-Apr-10 11:10

In a one-day special Topeka pointed me here[^], maybe that helps.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Getting an article published on CodeProject should be easier and faster.

Re: Reading Basic PDS ISAM Files

PIEBALDconsult1-Apr-10 13:42

PIEBALDconsult

1-Apr-10 13:42

Is it C-ISAM? I saw a mention of that in my search, I think in some Jet Engine documentation.

Re: Reading Basic PDS ISAM Files

Luc Pattyn1-Apr-10 13:57

Luc Pattyn

1-Apr-10 13:57

I don't know, the subject line said Basic PDS ISAM (not sure what it all means), however the one link looked interesting, however it might be all but relevant.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Getting an article published on CodeProject should be easier and faster.

Re: Reading Basic PDS ISAM Files [modified]

PIEBALDconsult4-Apr-10 14:45

PIEBALDconsult

4-Apr-10 14:45

Hee heeee!! I just installed MS Basic PDS 7.1 on my Win XP system!

During the install, there is the option for using a TSR for ISAM or building the routines into the program -- I chose the latter.

Now to see whether or not I can wrap the ISAM routines in a DLL that I can access from .net... Cool | :cool:

Edit: Maybe I shouldn't have selected that option. Or maybe it just won't work on XP.
I built the ISAMDEMO app, but it keeps reporting not enough ISAM buffers.
I tried linking in the ISAM routines (see here[^]), but to no avail. Sigh | :sigh:

modified on Monday, April 5, 2010 12:04 AM

Re: Reading Basic PDS ISAM Files

rmiller107-Apr-10 9:46

rmiller10

7-Apr-10 9:46

Sorry for the late reply, I've been on vacation.

That was the same site I had tried and got an error, so I went back and tried again, clicked the button, and nothing happened, but no error. I am at work, so it's possible it's a firewall issue.

Yes, the ISAM library links in to your source when you make the executable. I never tried the TSR. I'm not exactly sure how to convert the lib to a .net dll, but that might work for me.

I'm sure I can get it working by somehow getting the pds and developing software to read it, but that doesn't really solve my problem with porting it to Access. I would have to run the program each time I needed to grab some data and then import it.

Many Thanks

Re: Reading Basic PDS ISAM Files

rmiller107-Apr-10 9:53

rmiller10

7-Apr-10 9:53

PIEBALDconsult wrote:
Edit: Maybe I shouldn't have selected that option. Or maybe it just won't work on XP.
I built the ISAMDEMO app, but it keeps reporting not enough ISAM buffers.
I tried linking in the ISAM routines (see here[^]), but to no avail.

IIRC, there may be an environment variable that needs to be set.

find average of not null records

raghvendrapanda31-Mar-10 5:18

raghvendrapanda

31-Mar-10 5:18

Hy,
Is there any function through which i can find the average of the not null rows only.Like total/number of rows containg data
Thankz & Ragards
,
raghvendra Panda

Re: find average of not null records

R. Giskard Reventlov31-Mar-10 5:22

R. Giskard Reventlov

31-Mar-10 5:22

Why would you store rows that have no data?

In any case maybe what you are asking is how, for instance, do I get all records where one field is not null?

select count(*) from table where not column3 is null

might be close to what you want.

me, me, me

"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven

Re: find average of not null records

thatraja31-Mar-10 5:47

thatraja

31-Mar-10 5:47

I hope it will help you.

NORTHWIND Database

SQL

SELECT 
COUNT(UnitPrice) AS [NoOfItems], SUM(UnitPrice) AS [TOTAL], AVG(UnitPrice) AS [AVERAGE] 
FROM Products 
WHERE UnitPrice IS NOT NULL

OUTPUT

NoOfItems   TOTAL                 AVERAGE
----------- --------------------- ---------------------
77          2222.71               28.8663

thatraja

Tips/Tricks|Brainbench certifications

Re: find average of not null records

raghvendrapanda31-Mar-10 5:55

raghvendrapanda

31-Mar-10 5:55

Thnks for ur reply I had taken avg(isnull(column),0)..is that the reason why my function is also considering null rows also?

Re: find average of not null records

Chris Meech31-Mar-10 7:21

Chris Meech

31-Mar-10 7:21

raghvendrapanda wrote:
avg(isnull(column),0)..

The answer is yes, but as a test why don't you try the following.

avg(isnull(column),42) ..

Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

Re: find average of not null records

Luc Pattyn31-Mar-10 8:06

Luc Pattyn

31-Mar-10 8:06

I see, the "average" function needs to be calibrated first. Laugh | :laugh:

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Getting an article published on CodeProject should be easier and faster.

Re: find average of not null records

Chris Meech31-Mar-10 8:11

Chris Meech

31-Mar-10 8:11

Just like the random function needs to be seeded. Big Grin | :-D

Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

Re: find average of not null records

PIEBALDconsult31-Mar-10 8:33

PIEBALDconsult

31-Mar-10 8:33

I'm not sure that the WHERE UnitPrice IS NOT NULL is required here -- COUNT(UnitPrice) will only count the non-null entries anyway, right? Same with SUM and AVG?

search only date

test-0931-Mar-10 1:46

test-09

31-Mar-10 1:46

select a.*, b.ConstructionCompletionDate_dt  from projects a join schedule b on  a.projectid=b.projectid where projectname like @projectname or  country like @country or clientcompany like @clientcompany or ConstructionCompletionDate_dt like ('%(@ConstructionCompletionDate_dt)%')

this is how im searching.. where ConstructionCompletionDate_dt isonly yyyy from datetime field..
if im using '% %' for example if i search 2010,, all fields with 012 in mm/dd/yyyy are displaying... i want only rows with year 2010 how can i do..

Re: search only date

Eddy Vluggen31-Mar-10 3:07

Eddy Vluggen

31-Mar-10 3:07

test-09 wrote:
where ConstructionCompletionDate_dt isonly yyyy from datetime field

A real DateTime field that you converted to a VARCHAR(4)? The LIKE operator is more suitable to search through text-fields.

How about something like this;

SQL

SELECT *
  FROM HumanResources.Employee
 WHERE YEAR([BirthDate]) = 1972

I are Troll Suspicious | :suss:

Re: search only date

Mycroft Holmes31-Mar-10 3:08

Mycroft Holmes

31-Mar-10 3:08

Tell me you are storing your dates as datetime and not varchar.

Try the datepart keyword, something like

where datepart(yyyy,ConstructionDate) = 2010

Never underestimate the power of human stupidity
RAH

Re: search only date

test-0931-Mar-10 3:14

test-09

31-Mar-10 3:14

im storing it as varchar as this is comfortable to my requirement..

Re: search only date

dan!sh 31-Mar-10 5:00

dan!sh

31-Mar-10 5:00

You should use the correct data type then. Why are you not using Date as the datatype? You will be doing some casts and converts in your application which is error prone.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.