How do i creat tables in Openoffice Base useing SQL scripts?
121225
OpenOffice Base uses HSQL as its internal database engine. HSQL uses mostly standard SQL92 and SQL99 sytanx. Here's a link to the HSQL create table syntax:\nhttp://hsqldb.sourceforge.net/doc/guide/ch09.html#create_table-section\n\nIf you're wanting to programatically create a table from within Base, you'll probably be using macros. Here's a barebones example of what the code would look like: \n\noBaseContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")\noDB = oBaseContext.getByName(dbURL)\noCon = oDB.getConnection("", "")\noStmt = oCon.createStatement()\nsSql = "CREATE TABLE MYTABLE (ID INTEGER NOT NULL IDENTITY PRIMARY KEY, NAME VARCHAR(255) NULL, DATA LONGVARBINARY NULL)"\noStmt.executeQuery(sSql)\noDB.DatabaseDocument.store()\noCon.close()\n\nI adapted that from an example on page 18 of Andrew Learns OOo Base, http://www.pitonyak.org/database/AndrewBase.pdf. It goes into much more detail.
467004
Sounds like you want to use a database like Filemaker. With a database you can create custom reports that could be used as tests.
34098
You can get OpenOffice help here:\nhttp://support.openoffice.org/index.html\n\nDownload the newest version (2.0.2) here:\nhttp://www.downloadopenoffice.org/free_download.htm\nand get 30 days free support.\n\nGood luck.
192501
Go to openoffice.org page. there may be something there for you. This is not a guarantee or a promise. Just a suggestion.
467058
You don't need an expert to do this for you as someone has said. You do however need to steer away from Excel and start using a database. MySQL and PHP is probably the most user-friendly way of getting this done, but it will still require you to know a little of coding with MySQL and PHP...\n\nRawlyn.
564891
I hate the darn things. I have one in my name and it's a real pain.\n\nApplications written in SQL have a real problem with them too and usually error out if you include one.\n\n\nOther than that it's just plain lazy.
590175
As far as I know it's not possible. You'll have to use Word or a similar program like in OpenOffice.org
335038
TO set up the tables you need to log into your mySQL database once in there you need to set up the tables with the create command. I think is something like this, \nCREATE TABLE tbl_name\n    [(create_definition,...)] this would be your columns\n    [table_options]\nhmmm.... i think that is it, do a search on create tables in mySQL you will get a lot of info.\n\nIf you have a GUI then just try to find the field were you set up the table then edit it and add the columns that you require.
613564
Please note for any of this to work you have to have the project references include the Microsoft ActiveX Data Objects library\n\ndim conn as new ADODB.Connection\ndim rs as new ADODB.Recordset\n\n'Tell your connection what and how to connect\nconn.ConnectionString= "DSN=DSNname;UID=SqlServerUserID;pwd=SqlServerPassword"\n\n'open the connection\nconn.open\n\n'Run your SQL Query\nset rs = conn.Execute("Select * from datatable")\n\n'See if any records were returned we do this\n'by seeing if the recordset is simoultaneously reporting\n'that it is at the beginning and end of the record set\nif not rs.EOF and not rs.BOF then\n\n\n     'Get the field by field name\n      myValue=rs("fieldName")\n\n     'Get the field by position in the return set\n     'This is a zero baed index\n      mySecondValue= rs(3)\n\n     'Now I move to the next record. \n     rs.MoveNext\n\n     if not rs.EOF then\n          'Get another value\n           myValue=rs("FieldName")\n     end if\n\nend if\n\n'now close and clean up\n\nconn.Close\nset rs = nothing\nset conn=nothing
425214
try  http://www.openoffice.org
483
Sorry in advance if Yahoo eats my indentation, but I think you are looking for something like this (tested under Access 2000):\n\n\nPublic Sub FiddlingWithQueryObjectsViaVBA()\n\n    Dim dbs As DAO.Database\n    Set dbs = CurrentDb\n    Dim qrydef As QueryDef\n    \n    Dim sSQLstring As String\n    Dim sQueryNames As String\n    \n    For Each qrydef In dbs.QueryDefs    ' iterate through all the Access query objects\n    \n        sSQLstring = UCase$(qrydef.SQL) ' Get the SQL for the current query\n        \n        If InStr(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR") > 0 Then   ' I found what I'm looking for?\n        \n            sSQLstring = Replace$(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR", "REPLACEMENT_TEXT") ' replace the text\n            qrydef.SQL = sSQLstring     ' update the query object with the new SQL\n        \n            sQueryNames = sQueryNames & qrydef.Name & vbCrLf    ' Maybe make a list of queries modified?\n        End If\n    \n    Next\n    \n    MsgBox "Modified the following queries:" & vbCrLf & sQueryNames\n    \nEnd Sub
155575
The easy way to write a SQL script is to go into Access, create a query, and then view the SQL source behind it.
422655
I havn't done it mysqlf but a good place to start is with the TI-83 SDK and the documentation. The headers and required includes usually have a lot of information on how they can be used and often have a brief tutorial/starter project to build off of.
21155
hi , you dont need cursor \ntry this:\n\n-----------------------------------------------\n\nCREATE PROCEDURE test_sp\n\n@username1char(10),\n@username2char(10)\n\nAS\n\nDECLARE \n\n@UserTempTableTABLE ([ID] char(10),\n [USERNAME] char(10),\n [NAME] char(10),\n [ADDRESS] char(10))\n\nINSERT INTO @UserTempTable\nSELECT[ID],\n[USERNAME],\n[NAME] ,\n[ADDRESS]\nFROM    Table1\nWHERE[USERNAME] = @username1\n\nINSERT INTO @UserTempTable\nSELECT[ID],\n[USERNAME],\n[NAME] ,\n[ADDRESS]\nFROM    Table2\nWHERE[USERNAME] = @username2\n\n\nSELECT [ID],\n[USERNAME],\n[NAME] ,\n[ADDRESS]\nFROM@UserTempTable\nGO\n\n-----------------------------------------------
321630
SQL Plus has its own system to put query in file.\nyou type 'ed' at SQL Plus prompt and notepad editor edits your querry.\nYou can save as query by selecting save as "All Files" then giving the file extention to .sql\nhope this will solve your problem.
279322
Open SQL server Enterprise manager, open tools menu -> data transformation services -> import data. Under that give the access file and import whatever table you want. If you have any query just mail me to ragavendrang@gmail.com
437999
dim db as database\ndim rs as recordset\ndim strSQL as string\ndim strA as string\ndim strB as string\ndim strC as string\n\nset db = currentDB\n\nstrSQL = "Select fieldA, fieldB, fieldC from Table1 where FieldD = fieldvalue"\n\nset rs = db.openrecordset(strSQL, dbOpenDynaSet)\n\nif not rs.EOF then\nstrA = rs!fieldA\nstrB = rs!fieldB\nstrC = rs!fieldC\n\nend if