Unify SQLBase

Unify SQLBase

When I was doing my project in SQL command, there is a confusion arisen that what is the difference between In and Exists in SQL. When to use what?

  • 180 views
  • 1 answers
  • 0 votes

I am doing a project related to SQL. I am stuck with the problem of how to find the difference between two dates in SQL. Which commands to use?

  • 142 views
  • 1 answers
  • 0 votes

Hello,

I use SQLite 3 to build an encrypted database. But when I try to open the database with a browser, an error message appears and it says that the file is not a SQLite 3 Database.

Please find the below screenshot for your reference.

Could anyone suggest some solutions please?

Thank you very much.

File is not a SQLite 3 Database

SQLite Database Browser

An error occurred: File is not a SQLite 3 Database

 

  • 3249 views
  • 2 answers
  • 0 votes

Techyv! I need help with SQL. Some guide here on how to filter the data that did not match any records. It will be a great help guys! Thanks so much in advance.

  • 848 views
  • 1 answers
  • 0 votes

I already have a database using Microsoft SQL Server 2008.

I need to program the dataset to retrieve data using SQL server with an application in desktop.

Can it support code samples for Visual Basic?

Can I use the dataset in Microsoft Windows mobile?

  • 784 views
  • 1 answers
  • 0 votes

We are trying to install ConfigMgr 2012 on a primary site and this scenario is giving errors. An SQL named instance is supported by ConfigMgr which a known fact. Then there should not be any errors.


Error:

Could not connect or execute SQL query. Click the view Log button for more information.

  • 871 views
  • 1 answers
  • 0 votes

Hi, 

My UnifiySQL base is running at a very high CPU load but I don't have any process running. Here is  what I did before it happened: 

I just installed SP2 in place of  SQL Base 11.5 SP1.

Deactivated SQL Service and Resource Manager service

Closed the GUI and restarted my Windows Server

And just after that, the dbntsrv.exe process just went to 100% even without any connection. 

 

What can I do to solve this problem?

  • 2321 views
  • 2 answers
  • 0 votes

Hello everyone

Can anyone tell me what are the DDL and DML commands Unify SQL Base supports? What are the Data Types and Bind Variables in Unify SQL Base?

Thanks

  • 1084 views
  • 1 answers
  • 0 votes

What is the difference between InnoDB and MyISAM table types and how can I choose among the best in different situations? Is it possible to use the both MyISAM and InnoDB table types in a single database?

  • 742 views
  • 1 answers
  • 0 votes

Hello everyone,

Recently, I downloaded the latest Service Pack (SP3) of Team Developer 5.2  from the Unify web site. I used SQLBase as the backend and I was getting the OBJ_NULLerror. I am developing a small web application using this program when the error happened. Aside from that I also get crashes with both TW (after 30K rows) and GRID (after 23K rows) with v5.2 SP3. I also noticed that the application exits without any warning. Anybody who can confirm this?

I would be enormously grateful if someone could help me fix this problem..

Thanks in advance to those who will offer solutions.

  • 778 views
  • 1 answers
  • 0 votes

Articles

Blogs

Tips