Stack Overflow
Stack Overflow

Questions tagged [sqlbase]

SQL DBMS Development by Gupta Technologies

SQLBase is a very low TCO embedded and workgroup database offering high performance and scalability. Automated mass deployment, automated installation and automated maintenance make SQLBase the database of choice for environments with limited IT support. Many driver options allow for easy integration with many dev tools. SQLBase is a highly secure database offering powerful encryption for your valuable data and data communication. Go here for more info: SQLBase info

59 questions
4
votes
1 answer

ODBC Driver or .NET DataProvider for Centura SQLbase needed

For a Customer we need to import data from an old Centura SQLBase 7.5.1 database. The best way would be to connect directly from .Net to the customers database, but I can't find a driver or .Net Connector to use. So far I found out that the…
Jürgen Steinblock
  • 30,746
  • 24
  • 119
  • 189
4
votes
1 answer

SQL Sort by temporary "AS" column

I want to sort my result by a column that I actually create temoprarly SELECT A, B, @MID(C,2,2) as X FROM foobar ORDER BY X DESC I know this would work in MySQL but it doesn't seams to work in SQL (SQLBase). Any suggestions? I tried: SELECT A, B,…
Dwza
  • 6,494
  • 6
  • 41
  • 73
3
votes
2 answers

Get Current date in SQLBase

I have an SQLBase and I am trying to get the current date of the system to be equal to the date of a column (create_date). The MySQL Code will be: Select * From Date D Where D.Create_date=CURDATE(); Can someone suggest me a way to take the current…
Mike M. Kaspin
  • 81
  • 9
3
votes
2 answers

Cannot add SQLBASEUTIL.dll (Gupta) as reference to C# - VStudio 2012

I am doing a C# project in Visual Studio 2012 (x86). I was able to add Gupta.SqlBase.Data to the project but when I run the project if gives me an error related to SqlBaseUtil.dll. Unable to load SQLBASEUTIL.dll driver library. Please check your…
Gomorad
  • 31
  • 1
2
votes
2 answers

How to copy performant data from one database to another database?

I have a conceptual question. I have two databases which have the same structure. One database has already contained a lot of data. These data should be transferred to the other database via Select and Insert. How can I do this data migration with…
Bambuk
  • 192
  • 1
  • 15
2
votes
3 answers

SQL-Select ends up in an Error when combined

I try to do a simple select for some duplicates but my sql statement always end up with this error: Command not properly ended What I have is a table like this EAN STR ============= ==== 8030524096397 AAAA 8030524096397 …
Dwza
  • 6,494
  • 6
  • 41
  • 73
2
votes
1 answer

Possible to change format of NHibernate formulates bind variables?

I am working on a legacy SQLBase database and am trying to set up a new project with NHibernate. A big problem is the format SQLBase expects the bind variables in the SQL to be. The format has to be explicitly INSERT INTO ... VALUES (:1,:2,:3);…
Aether McLoud
  • 732
  • 1
  • 7
  • 20
1
vote
3 answers

Cannot open include file "sqlapi.h" in C++?

I am trying to connect c++ with SQLBase. After building my project I get an error as " Cannot open include file: 'SQLAPI.h': No such file or directory ". #include #include // main SQLAPI++ header #include Can…
digvijay
  • 189
  • 1
  • 5
  • 16
1
vote
1 answer

SQLBase union doesn't work with alias. Why?

I am trying to execute a SQL query using UNION in my SQLBase database. Also I want to use an alias for the column. But it doesn't work with the alias. I've never used UNION but I always use alias. It works: SELECT color FROM my_table UNION…
Roby Sottini
  • 2,117
  • 6
  • 48
  • 88
1
vote
1 answer

A replacement for the simple SQLTalk

I am using SQLTalk for Windows, version 10.0.0-PTF1 Build 13914. It is a very simple database administrator: I use PgAdmin for PostgreSQL and it has many tools. But SQLTalk doesn't have, for example, undo feature (CTRL+Z). So I would like to know if…
Roby Sottini
  • 2,117
  • 6
  • 48
  • 88
1
vote
1 answer

centura team developer 2.1 open same form twice

I'm working in centura team developer 2.1 I have already made an app with a lot of forms. When running my app I need to open a specific form window twice at the same time. Any idea how to do this?
BODYBOND
  • 117
  • 1
  • 4
  • 12
1
vote
4 answers

SQL Select GROUP BY part of field if has a special char

Is there a way to GROUP BY a part of a string.... I wanted to create a SQLFIDDLE but they seem to have to serverproblems, so I have to make it visible here.... This would be the data... CREATE TABLE tblArticle ( id int auto_increment…
Dwza
  • 6,494
  • 6
  • 41
  • 73
1
vote
1 answer

MVC Controller and Com Object VB .Net

I have a development where i made a Com dll to communicate with Centura SQLBase: COM DLL Code adaptor.SelectCommand() = New SQLBaseCommand("SELECT COMPANY_ID,COMPANY_NAME FROM COMPANY", myConnection) Dim ds = New DataSet() adaptor.Fill(ds,…
Hackerman
  • 12,139
  • 2
  • 34
  • 45
1
vote
3 answers

Centura Gupta Team Developer Automation Possibility

Is there a automation tool which can automate the software build on Team Developer (v6.0). I have tried with multiple automation tools to spy the table object in the application, it identifies it as Gupta ChildTable. But I am not able to retrieve…
user3498061
  • 11
  • 2
1
vote
2 answers

SQLbase data not numeric

I have a query that runs in Excel, that will need to show data from an SQLbase database where I only have read-access. I cannot modify the database in any way. The column I need to be able to filter on is a varchar column, but it's values are only…
Deep Frozen
  • 2,053
  • 2
  • 25
  • 42
1
2 3 4