Search results for query: *

How do I compare a date string in yyyymmdd format to the current date?

It's been a long time since I worked with sql/pervasive/Delphi. I have a query that returns 3 records. I can't remember how to access the result of the query record by record. Help would be appeciated. form1.CliGrid.Cell[1,I] := PvQuery1.ClientNumber; PvQuery1 is the query. It returns x...

In D7, the following pervasive sql statement returns the result multiple times. Why? Thanks. JimR procedure ShowContracts; var L : string; begin L := form1.tbCLient.FieldByName('ClientNumber').asString; form1.PvSQLSession1.ServerName := 'Btrieve'; form1.PvQuery1.DatabaseName :=...

Linux v9.1. Somehow one of my database's seems to have disappeared from the pcc, although the tables and ddf's are where they are suspossed to be. I can't seem to recreate the database name in the pcc. It always says the database is in use. Great. How do I get the database name to show up...

I cannot get the workgroup to work at all. The pcc won't run, it aborts. The psa gives me an error 11 on transactional testing on the local machine. When I try to run odbc, I get: [{ervasvoe][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager]no such table or...

I'm using the statement below to create the primary key on a table. The key needs to be non modifiable. I can't see anyway to include that restriction with this statement. Would it be more appropriate to use a create unique index statement instead? ALTER TABLE adspxapi in Dictionary ADD...

I am define all my tables with sql statements. I can't seem to get the syntax right to create a NON Case Sensitive key. My code is Create UNIQUE INDEX ByDesc in dictionary ON Zones (ZoneDescription NO CASE,PubNumber,ZoneCode) # Do I use NO CASE or is there something else I have missed? If...

How do I use sql (Pervasive v8.7) to copy data in a particular field to another field in the same record and save the resultant record. Any help would be appreciated. JR

How do I modify the sql command below to make the key case-insensitive? ALTER TABLE adheader IN Dictionary ADD PRIMARY KEY(AdNumber,EntryYear) # Thanks.

I have a test RedHat 4 server that I use to emulate my office environment. I would like to change the name of the server from it's current name (LINUX) to the same name as the server in my office. Can this be done and if so, how? Thanks.

I'm new to Linux. I have a server with RedHat 4 installed. I have samba configured correctly I think. There are 2 directories off the root that are shared and neeeded by all users. I can ping my xp workstation from redhat and ping redhat from my workstation. However I can't "see" the...

In v8.x of Pervasive, there was a database check funtion in the pcc. Is that same function in v9.1 and if so, where? JR

I have a field in a record that is defined as a 4 byte date in the ddf's. How do I select records that donot contain any information in the field? Are they nulls?

I have two tables I want to join. I want all the records in table a if they have a certain string in one field and all records in table b that match a field in a. I have tried more syntax's than I believed imaginable with absolutley no luck. It appears that pervasive doesn't support a left...

The following code gives me : [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Error in expression: :BilledDate procedure UpDateFJDataBase(AdNumber:string;BilledDate:tDateTime); var EntryYear : string; begin if (AdNumber[2]='C') then EntryYear := '2005' else...

When I run a query in Delphi, I need to know how many rows are affected, i.e. returned, from the query. The rowseffected propery always returns a -1 and it shouldn't. Thanks.

Why would the following query take a couple hours to run? Using regular table processing would be less than 1 minute. Table A has approx 10k recs, B approx 50k recs. SELECT adnumber, entryyear,EntryMonthDay FROM Tablea A where a.entryyear = '2005' and not exists (select * from Tableb B...

I'm trying to see if any record in AdHeader DOES NOT have a record in AdTextNew with the following sql statement. SELECT * FROM AdHeader where not exists (select adnumber, entryyear from adtextnew) It doesn't return any records from adheader which it should. Any idea why it doesn't?

Is there a decent sql generator available for Pervasive. I'm using 8.6.

I am getting this error from within, I think, a code based Rave6 report. Does anyone know what this might mean? madExcept version : 2.7d exception class : ETDBEngineError exception message : Btrieve Error 2999.DBI Error Code = Titan (BDE) Error 2999..