pervasive-sql

相关标签：javascript jquery android 多少钱 iPhone

Creating a DSNless connection to Pervasive in VBA

I\'m very new at connecting to databases so I apologise if I\'m not familiar with some of the terminology.[详细]

2023-03-30 05:15 分类：问答
Pervasive SQL GRANT syntax

I\'ve been Googling for half an hour now, and can\'t seem to find the right place... How do I add a user and grant that user access to all tables in the database? Found some GRANT snippets, but there[详细]

2023-03-14 20:57 分类：问答
Year, Month, and Day parameters describe an un-representable DateTime how to ignore

I am using ODBC to read data from a pervasive PSQL database a开发者_运维问答nd in some scenarios, the date column can contain 00/00/0000 date. I don\'t really care about invalid dates so is there some[详细]

2023-03-07 19:44 分类：问答
Pervasive SQL ADO.NET data provider

I have an asp.net, c# application using MSSQL 2008 server. At some point, i also want to insert some d开发者_运维技巧ata into a pervasive v10 database. Was looking for the pervasive data provider from[详细]

2023-02-17 01:16 分类：问答
Get latest exchange rate for all currencies

I have a database with a lot a currencies and each row has a currency, d开发者_运维问答atestamp and the exchange rate. What I would like to have is a query that gets me the latest exchange rate for al[详细]

2023-02-04 06:54 分类：问答
Select max date row from results

Using Pervasive SQL, I have a result set: Tp_NoNameStateEff_DateActualBilled 1006ABCTN2006-07-01.1.5 1006ABCTN2008-02-15.27.6[详细]

2023-01-15 01:55 分类：问答
Improving SQL Code

I\'m using Pervasive SQL.I have the following UNION of mulitple SQL statements.Is there a way to clean this up, es开发者_JAVA技巧pecially the Pay Date an the Loc No fields that are selected in each st[详细]

2022-12-28 09:35 分类：问答
SQL How to find out what tables have a certain column

Is it possible to const开发者_StackOverflowruct a query so that I can find out what tables have a particular column? Then if it has the column query that table for an ID number? Is this possible?Sure,[详细]

2022-12-18 06:07 分类：问答
Most efficient way to select records in one database based on result set from totally different database

I have 2 totally separate databases - one MSSQL and one Pervasive.Due to the way our product data is stored in the Pervasive database, you cannot easily run a query to get a products\'s information an[详细]

2022-12-14 07:03 分类：问答