Dbase

dbase

Great Reads

Get Ready to Learn SQL Server: 14. Introduction to Outer Joins

by essentialSQL

Introduction to Outer Joins in SQL Server

XMeLon Schema

by Alejandro Xalabarder

Yet another XML to database aproach

XML Databases

by AlexTatiyants

JSON-oriented document stores like Mongo and Couch have really become the darlings of the web application crowd. Of course, JSON (or BSON) isn't the only game in town. When it comes to document store formats, the other white meat if you will is XML.

SQL recursive common table expression in Project Scheduling practice

by csabahegyi79

Project Scheduling Engine with recursive SQL common table expression

Latest Articles

SQL recursive common table expression in Project Scheduling practice

by csabahegyi79

Project Scheduling Engine with recursive SQL common table expression

Get Ready to Learn SQL Server: 14. Introduction to Outer Joins

by essentialSQL

Introduction to Outer Joins in SQL Server

XMeLon Schema

by Alejandro Xalabarder

Yet another XML to database aproach

XML Databases

by AlexTatiyants

All Articles

top

Dbase

Get Ready to Learn SQL Server: 14. Introduction to Outer Joins

22 Oct 2014 by essentialSQL

Introduction to Outer Joins in SQL Server

SQL

dbase

SQL-Server

How can I open dbf file in dbase?

28 Feb 2015 by Mehdi Gholam

Start here : Importing a DBF file into C#[^]

dbase

Inventory system db ,c#

9 Mar 2016 by ZurdoDev

To update the quantity, just run an UPDATE sql statement. Very simple:UPDATE productsSET quantity = quantity - 1WHERE product_id = @product_id

dbase

DBF SQL standard to escape column names?

1 Nov 2023 by M Imran Ansari

The error message is clear that tha column name 'HOUR' is not being recognized in the table or not spelled correctly, you are trying to insert data into. The INSERT INTO statement contains the following unknown field name: 'HOUR'. Make sure you...

SQL

dbase

OleDb

read data from a dBase III file using c#

16 May 2012 by Pallab_GT

Hello my learned friends.I have to read data from a dBase III file using c#. Can anyone please guide me to a tutorial? Any sort of help would be highly appreciated.

dbase

read data from a dBase III file using c#

16 May 2012 by Wendelius

In order to use dBase you would need to use an ODBC driver and for example OLEDB connectivity in ADO.NET. Few example which are not for dBase but they show how to use OLE DB functionality:- Using ADO.NET for beginners[^]- ADO.NET Code Examples[^]Side-note, dBase III is really old product...

dbase

update *.dbf file using data in each cell in *.xls file

20 Mar 2013 by Maciej Los

You need something like this: Dim ConnectionString As String = String.Empty, sCommand As String = String.Empty Dim rCnt As Integer = 0, Empno As Integer = 0, Otvalue As Integer = 0, retVal As Integer = 0 Dim xlApp As Excel.Application = Nothing, xlWorkBook As...

dbase

MS-Excel

OLEDB DBase VI :Syntax error in field definition

1 May 2013 by SalouaK

Yes , ryanb31 you're absolutly right , Level is a reserved word and the best thing is t not use reservedword a think of a better nomenclature , but since a whole system use those same nomenclature I cannot change, at least not right now, The good News is I have find a work around, Use (`)...

dbase

OleDb

How to restore/load dbf to extract data

12 May 2013 by Sudhakar Shinde

Even though oracle fetches data from the DBF files, they are NOT a valid backup. The only way to recover the data is to create a new oracle database using the same version that the datafiles were running in and recover the database.Please note that you cannot restore a file without knowing the...

dbase

Oracle

display dbf file into list view in vb.net

30 Jun 2013 by xana7900

hi...i have some code here display all data..the problem here is how can i get the second column of the data? i only can get the first column. here is my code..can u help me? Private Sub dbffrm_Load(sender As Object, e As EventArgs) Handles MyBase.Load Companydbf =...

dbase

display dbf file into list view in vb.net

30 Jun 2013 by xana7900

Private Sub ListView1_SelectedIndexChanged(ByVal sender As _ System.Object, ByVal e As System.EventArgs) _ Handles ListView1.SelectedIndexChanged If ListView1.SelectedIndices.Count = 0 Then Return Dim lvi As ListViewItem = _ ...

dbase

How to restore/load dbf to extract data

22 Sep 2013 by Jörgen Andersson

Forget using the backup or dbf files. You would need an almost identical setup as the server the files originate from (file system, setup files and user accounts, and probably a lot more.)The appropriate way to do it on Oracle is to import an export[^] file.

dbase

Oracle

Reindex dbase file from linked access 2007

3 Mar 2014 by bijukmv

I am inserting some records from access 2007 in linked foxpro file.But when I try to view these records from Foxpro. It is not showing any of the records inserted from Access 2007, till i refresh index filesRe-indexing is not possible when file is "set exclusive off"Is there any...

dbase

MS-Access

How to filter the date in dbase

19 May 2015 by basitsar

Dear,I want to access dbase database and fill in DataGridView in .Net. When i tried this code with passing date value in where Claus not filtering, but without where Claus its working fine. Please help on thisThanksBasit Try Dim ConnectionString As String ConnectionString...

.NET

dbase

How to filter the date in dbase

19 May 2015 by Leo Chapiro

The problem is that dBase/xBase doesn't support "between" for SQL datesTry this:Quote:date = #" & Format(Today.Date, "mm/dd/yy") & "#

.NET

dbase

How to filter the date in dbase

19 May 2015 by Richard Deeming

To fix the SQL Injection[^] vulnerability in your code, use a parameterized query:Using dBaseConnection As New OleDbConnection(ConnectionString) Using dBaseCommand As New OleDbCommand("SELECT * FROM ATTEND.DBF Where date = ?", dBaseConnection) ...

.NET

dbase

How to use dbf (dbase) file?

24 May 2015 by GilesMas

Hello I am a visual basic programmer and I know nothing about foxPro. I am given a dbf file I do not the dbase version . I need to develop an vb application what will work on it and insert data into the sql server database. I have download the foxPro driver to use with ADO . While I am trying to...

SQL

VB6

dbase

How to use dbf (dbase) file?

24 May 2015 by Maciej Los

Please, start here: Developing Visual FoxPro Applications[^]

SQL

VB6

dbase

DBF error. Can't reindex

17 Sep 2015 by Dave Kreskowiak

Well, you're not going to solve it here. Contact the vendor support for the application.

dbase

DBF error. Can't reindex

17 Sep 2015 by Patrice T

patients.cdx is probably corrupted to the point it can't be repaired with REINDEX.One possibility is to find even a very old patients.cdx file copy it with the other data files and REINDEX.Otherwise, one need to reconstruct the cdx file but you have to know the formula and the compiler...

dbase

DBF error. Can't reindex

23 Sep 2015 by donavon32

Perform these actions to resolve this issue, otherwise I would offer you following topics, last one solution only for hardly crashed .dbf...

dbase

Inventory system db ,c#

9 Mar 2016 by Kho Dam

It is been a month i am working on inventory management system using c#, it has stock managment to so we can add items that how much we have in our hand but when i sell it from purchase form how to cut down its quantity from database.Sorry for my bad english.What I have tried:I tried...

dbase

Run time error 3021 - EOF or BOF is true or the current record has been deleted

2 Jul 2016 by Member 12556431

Run time error 3021 - EOF or BOF is true or the current record has been deletedWhat I have tried:i install application in my pc and show this error so what can i do please help me

dbase

Run time error 3021 - EOF or BOF is true or the current record has been deleted

2 Jul 2016 by OriginalGriff

We can't help you based on that little information: we have no idea even what language your app is written in!So start with Google, and try the whole error message: Run time error 3021 - EOF or BOF is true or the current record has been deleted - Google Search[^]You'll see that it returns a...

dbase

How can I count the occurrence of a word from a different table(table 2) field by comparing it with table1 field value?

15 Aug 2016 by Danyal Awan

I want to count the occurrence of word from a field of table 1 than compare it with a field of table 2 that how much time it occurred and than store it in table 1. I want this in MS ACCESS.I have a Table (Gap Summary) in that I have a Field (Data Domain) and I have another Table (TOC Data...

dbase

Microsoft

MS-Access

How can I count the occurrence of a word from a different table(table 2) field by comparing it with table1 field value?

15 Aug 2016 by OriginalGriff

Like operates with a string: and that's what you are giving it. So it's looking for anything, followed by the text "[table name].[column name]", followed by anything else. That's not the content of the column, it's the text "[table name].[column name]".To look for the content of a column,...

dbase

Microsoft

MS-Access

Where can I find a jdbc for "dbf" file, and it can display chinese, and free.

14 Oct 2016 by Mehdi Gholam

Be friends with Google: GitHub - iryndin/jdbf: Java utility to read/write DBF files[^]JavaDBF Tutorial[^]GitHub - jamel/dbf: Java library for fast reading DBF-files.[^]...

dbase

JDBC

Not able to insert value into a column in a .dbf file

24 Mar 2017 by erick manuel

BackGroundI am currently working on a project which will need me to create a local .dbf file which I must then populate with a value. I am currently able to create a .dbf file in a test dir and add a column to it, however when I try to add a value to that column it is not allowing me to do...

dbase

OleDb

Not able to insert value into a column in a .dbf file

24 Mar 2017 by erick manuel

The error was purely syntax, and I was guided by a really good example which I found in the following linkhttps://social.msdn.microsoft.com/Forums/en-US/24eac4c5-3a4d-43f4-8607-ef684919c4af/command-contains-unrecognized-phrasekeyword-vbnet?forum=visualfoxprogeneralpublic static bool...

dbase

OleDb

Selected option value get from db into dropdown using oop PHP mysql ! !

22 Aug 2018 by Shaher11

"> selectSchool();?> //php class public function selectSchool() { $sch=mysqli_query($this->conn,"select * from school "); while ($row = mysqli_fetch_array($sch)) { echo...

MySQL

dbase

PHP

Selected option value get from db into dropdown using oop PHP mysql ! !

22 Aug 2018 by Shaher11

Quote: echo " $row1[1] ";

MySQL

dbase

PHP

How to identify .dbf file

6 Nov 2018 by priyanka456

I have a requirement to import dbase database in sql server.I have a folder which contains many .dbf file.First how i will identify which is actual file(containing file structure and data) in folder. What I have tried: I am new to dbase,Plz help me out. Thanks in advance.

dbase

How to identify .dbf file

6 Nov 2018 by RickZeeland

For Xbase - and dBASE III to 5, see table here: Xbase Data file (*.dbf)[^] If you don't have Dbase installed, and want to inspect the files you can use a universal editor like Database .NET - An Intuitive Multiple Database Manager[^]

dbase

How to identify .dbf file

6 Nov 2018 by Patrice T

Any .dbf file is a database file and contain its structure and related data. Note that a .dbf is only a table, it is not relational. .dbf - Wikipedia[^] I used to open them with Excel and Access

dbase

How to check if exists a row before insert - PL/SQL

4 May 2022 by Jose Ewerton Alves Bezerra

Im new with SQL, and I want to knw how can I add a SQL in this structure to check if the row already exists before insert, Im tried this way, but I think its not the best. DECLARE v_project_id NUMBER; v_group_name VARCHAR2(100); ...

SQL

dbase

Oracle

How to check if exists a row before insert - PL/SQL

4 May 2022 by Member 11131110

SQL best way I can think of is add it like this:IF NOT EXISTS ( select 1 FROM APP_PROJECT_GROUP WHERE GROUP_NAME = :v_group_name AND USER_ID = :v_user_id ) BEGIN INSERT INTO APP_PROJECT_GROUP (GROUP_ID, GROUP_NAME,...

SQL

dbase

Oracle

How do I fix an all of a sudden SQL connection issue?

17 Sep 2022 by David Jr woll

I have a app to manage workflow at my work company, and a few days ago one table stopped loading. I have searched for help on various platforms and so far found none. I have a private 2016 SQL server that a connect to. My Connection SQL Command:...

SQL

dbase

How do I fix an all of a sudden SQL connection issue?

17 Sep 2022 by Dave Kreskowiak

Quote: 1) A severe error occurred on the current command. The results, if any, should be discarded. I don't have a solution for this. Quote: 2) The relationship between the two objects cannot be defined because they are attached to different...

SQL

dbase

DBF SQL standard to escape column names?

4 Nov 2023 by Dave Kreskowiak

Just to reinforce the point that may have been missing, that is some horrifyingly bad code. It's near impossible for a newb to debug, isn't supportable n any environment, and would give code and security reviewers heart attacks. Google for "Sql...

SQL

dbase

OleDb

XMeLon Schema

12 Nov 2013 by Alejandro Xalabarder

Yet another XML to database aproach

XML Databases

21 Apr 2012 by AlexTatiyants

SQL recursive common table expression in Project Scheduling practice

14 Oct 2015 by csabahegyi79

Project Scheduling Engine with recursive SQL common table expression

update *.dbf file using data in each cell in *.xls file

20 Mar 2013 by xana7900

i write a program that i need to update in the *dbf file from data in the *xls file using specific id. now i have 2 problem that i need a help. 1, the error is display MsgBox("Can not open connection ! ") after i placed this: Dim dBaseCommand As New System.Data.OleDb.OleDbCommand("UPDATE...

dbase

MS-Excel

OLEDB DBase VI :Syntax error in field definition

30 Apr 2013 by ZurdoDev

Level is a reserved word. I would recommend not using it. In Microsoft SQL you use square brackets around it, [level], but a better idea is to think of a different word.

dbase

OleDb

OLEDB DBase VI :Syntax error in field definition

30 Apr 2013 by SalouaK

0down votefavoriteI am trying to create a DBF table when i get this error "Syntax error in field definition." , however there is nothing wrong with syntax , and when I change a certain column name from level to levels it debug just fine! anybody have an idea ? here is the code: string...

dbase

OleDb

How to restore/load dbf to extract data

12 May 2013 by ohh its true

Hey there ,I have a requirement where I need to load the data from dbf , svd ,arc , ctl ,obk file such that I can run select queries (with complicated joins)to extract the data from these files . These files are provided by 3rd party vendor by taking database back-up of an Oracle 11g...

dbase

Oracle

How can I open dbf file in dbase?

28 Feb 2015 by fernandoventura@mail2world.com

folks, I have a dbf file created in dbase IV. And I cant open it in dbase IV and dbase V. I need to open this file ASAP.Thanks you all.

dbase

DBF error. Can't reindex

17 Sep 2015 by dameonmalia

We have a software call Kodak Trophy. It is a dental database program. This program stores patient data with x-rays. Now it is giving an error saying that the database cannot be open. I have copied 3 main files call patients.dbf, patients.cdx and patients.fpt and added it to the folder. It...

dbase

Where can I find a jdbc for "dbf" file, and it can display chinese, and free.

14 Oct 2016 by Water1988

My project need to access some .dbf file. But I'd like use jre1.8, so I can't use odbc-bridge. I find some kind of jdbc. But they are not free, or can't display Chinese. What can I do?What I have tried:I used "htxx", but I can only use it 30 days. I find tinysql, but I can't display...

dbase

JDBC

DBF SQL standard to escape column names?

4 Nov 2023 by ramderf.0326

SQLInsertCommand = "INSERT INTO " & strFileName2 & "_ (TRANDATE,[HOUR],SALES,TRANCNT,TENTNAME,TERMNUM) " & _ " VALUES('" & Format(CDate(dr("dateid")), "Short Date").ToString & _ "','" & "" & dr("dhour") & "'," & _ Format(dr("amt"),...

SQL

dbase

OleDb