Click here to Skip to main content
14,360,894 members
   

Database

 
AnswerRe: I have a column and i need to find in which table this column exists throughout whole DB Pin
Jörgen Andersson8-Oct-19 22:11
protectorJörgen Andersson8-Oct-19 22:11 
Questionvb.net connection to a firebird database Pin
Member 767827622-Sep-19 18:15
memberMember 767827622-Sep-19 18:15 
How do i browse to let's say 10 records before the last one? Code below:

Dim con As String =
"User=SYSDBA;PASSWORD=masterkey;Database=/DATABASE/TIME_DBS/TC_SHPIRAG3ST4.gdb;Datasource=192.168.2.78;Port=3050;Dialect=3"
    Dim conexiune As FbConnection = New FbConnection(con)
    Private Sub Timer1_Tick(sender As Object, e As EventArgs) Handles Timer1.Tick
        conexiune.Open()
        Try
            Dim sCmd As FbCommand
            Dim sql As String
            Dim ds As FbDataReader
            sql = "select * from RT_TIME ORDER BY RTTI_COUNTER desc"
            sCmd = New FbCommand()
            sCmd.Connection = conexiune
            sCmd.CommandText = sql
            ds = sCmd.ExecuteReader
            ds.Read()

            TextBox1.Text = ds("RTTI_BIT_POS")
            Label1.Text = ds("RTTI_HOOK_POS")

            ds.Close()
            conexiune.Close()
        Catch ex As FirebirdSql.Data.FirebirdClient.FbException
            MsgBox(ex.ToString, vbCritical, "DB Error")
        End Try

    End Sub


modified 22-Sep-19 23:38pm.

AnswerRe: vb.net connection to a firebird database Pin
Victor Nijegorodov22-Sep-19 21:12
memberVictor Nijegorodov22-Sep-19 21:12 
GeneralRe: vb.net connection to a firebird database Pin
Member 767827623-Sep-19 12:06
memberMember 767827623-Sep-19 12:06 
GeneralRe: vb.net connection to a firebird database Pin
Member 767827623-Sep-19 17:16
memberMember 767827623-Sep-19 17:16 
GeneralMessage Closed Pin
1-Oct-19 16:26
memberhayac h1-Oct-19 16:26 
QuestionMoving from access DB to Oracle to calculate average upon request Pin
Member 1447460719-Sep-19 12:12
memberMember 1447460719-Sep-19 12:12 
AnswerRe: Moving from access DB to Oracle to calculate average upon request Pin
Gerry Schmitz19-Sep-19 13:26
mveGerry Schmitz19-Sep-19 13:26 
QuestionMySQL database Pin
Alboyz17-Sep-19 17:46
memberAlboyz17-Sep-19 17:46 
AnswerRe: MySQL database Pin
#realJSOP18-Sep-19 2:08
mve#realJSOP18-Sep-19 2:08 
GeneralRe: MySQL database Pin
Alboyz18-Sep-19 17:58
memberAlboyz18-Sep-19 17:58 
AnswerRe: MySQL database Pin
Mycroft Holmes18-Sep-19 13:44
memberMycroft Holmes18-Sep-19 13:44 
GeneralRe: MySQL database Pin
Alboyz18-Sep-19 17:58
memberAlboyz18-Sep-19 17:58 
QuestionDatabase suddenly slow Pin
Super Lloyd17-Sep-19 16:39
memberSuper Lloyd17-Sep-19 16:39 
AnswerRe: Database suddenly slow Pin
CHill6018-Sep-19 1:05
protectorCHill6018-Sep-19 1:05 
GeneralRe: Database suddenly slow Pin
Super Lloyd18-Sep-19 21:47
memberSuper Lloyd18-Sep-19 21:47 
AnswerRe: Database suddenly slow Pin
Richard Deeming18-Sep-19 2:01
mveRichard Deeming18-Sep-19 2:01 
GeneralRe: Database suddenly slow Pin
Super Lloyd18-Sep-19 21:47
memberSuper Lloyd18-Sep-19 21:47 
GeneralRe: Database suddenly slow Pin
Mycroft Holmes19-Sep-19 14:14
memberMycroft Holmes19-Sep-19 14:14 
QuestionI need this windows odbc driver Pin
Member 1458760611-Sep-19 9:00
memberMember 1458760611-Sep-19 9:00 
AnswerRe: I need this windows odbc driver Pin
OriginalGriff11-Sep-19 9:01
protectorOriginalGriff11-Sep-19 9:01 
GeneralRe: I need this windows odbc driver Pin
Member 1458760611-Sep-19 9:16
memberMember 1458760611-Sep-19 9:16 
AnswerRe: I need this windows odbc driver Pin
Maciej Los11-Sep-19 9:47
protectorMaciej Los11-Sep-19 9:47 
QuestionLooking for some assistance with a query Pin
FrankLepkowski10-Sep-19 10:50
memberFrankLepkowski10-Sep-19 10:50 
AnswerRe: Looking for some assistance with a query Pin
MadMyche10-Sep-19 12:12
mveMadMyche10-Sep-19 12:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.