pervasive
SQL Selecting record with highest ID
I have a issue with some SQL that I can\'t wrap my head around a solution. Right now the query I am running basically i开发者_运维知识库s:[详细]
2023-04-08 00:21 分类:问答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 PSQL 10 Database to MS SQL Server?
I want to migrate a Btrieve Database to Microsoft SQL Server 2008 R2. I already have done the step of migration to Pervasive PSQL 10 Workstation (x86), which offers an ODBC / OLE DB driver. (It seems[详细]
2023-03-29 05:11 分类:问答Is there some way to ascertain if the tableadapters underlying data has changed
I am retrieving data from my database using a TableAdapter. I was wondering if there is some way I can tell (or be informed) that the data has changed and I therefore need to do another Fill? That way[详细]
2023-03-25 04:58 分类:问答Timberline ODBC Error with TEMP Environment variable
I havestumper that\'s been causing intermittent error at a client which has been increasing in frequency.[详细]
2023-03-18 17:20 分类:问答sql replace function that matches whole words
I wish to replace some text within a field, so i have the following statement: UPDATE INVENTORY SET INV_DESCRIPTION = REPLACE(INV_DESCRIPTION, \'5 ml\', \'5ml (1/6oz)\')[详细]
2023-03-15 22:38 分类:问答optimizing SQL UPDATE with LIKE
I have tried running the following UPDATE on a table with about 25k rows and its been running for over 24hours and it has not compl开发者_运维技巧eted.I only need to run this UPDATE once so time is no[详细]
2023-03-15 04:13 分类:问答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 分类:问答ODBC Pervasive Error
I am having the hardest time connecting to this pervasive server for this asp.net application I\'m working on.Right now, I am able to access and view the entire database using my connection string in[详细]
2023-03-09 18:59 分类:问答ODBC connection problems
I\'m creating an asp.net application that gather开发者_运维知识库s information from a pervasive database. I\'m having a hard time getting the connection to work properly though.From my computer I am a[详细]
2023-03-09 02:08 分类:问答