Search results for query: *

Here is what I have in the sql statement" L := form1.tbCLient.FieldByName('ClientNumber').asString; form1.qAds.SQL.Clear; form1.PvSQLSession1.ServerName := 'Btrieve'; form1.qAds.DatabaseName := 'LPV8OE'; form1.qAds.SQL.Add ('select clientnumber, pubnumber, adnumber,entryyear,regarding...

I am using 9.5. I am entering the following select * from "adheader" where DATEDIFF(day,LastInsertDate,Current_Date())>0 I get [LNA][Pervasive][ODBC Engine Interface]Expression evaluation error. 2ndly, the LastInsertDate field is in yyyymmdd string format - no hypens. Is this going to...

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

Yes, that took care of the problem with the 2nd and later iteratios. Still I'm getting the results back more than once and the last set of data I see in the grid is the correct answer.

The query is set to display the result in a grid. The grid is attached to a data source. The data source is the query. The query works correctly in the pcc. Also the query doesn't display anything on a 2nd iteration.

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.

Thanks for the help. The change worked fine. JR

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 re-installed everything. I now can see all machines in the group on a windows box or the Linux box. So far so good. I don't know what to do for security. My Linux guy at this office set up a new redhat box with security = SHARE. Is this the way to go? Thanks.

I used part of your configuration and now I see the Samba server in my windows work group, at least from the windows machines. Havn't tried it from the linux box yet. However when I dbl click on the icon for the samba server I get : \\JimsLinux is ot accessible. etc etc etc The network path...

In Network Places on the RedHat machine, I see Windows Network. When I dbl click on that icon, I see nothing. I'm assuming I should see all the computers on the network that are in the "workgroup" group. I didn't see anything under interfaces in the smb.conf file.

Thanks for the replies. One of the problems I had was not seeing the linux server in the windows workgroup. I now see all my machines in the workgroup, so I think I've made progress. When I open workgroup and dblclick on the linux server I get \\JimsLinux is not accessible. You do not have...

I have one user defined. I think the problem may be elsewhere. I can't "See" the linux server in workgroups. Thanks.