Are there any programs with a gui which let you create a SQL database, create tables, define the primary and foreign keys and insert data? I am tired of having to use the mysql command line client, very tedious.
Dear reader,
I'm working on a project where the user can insert data into a document using fields, document properties and variables. The user also needs to be able to remove the data from the document. So far, I've managed to remove the document property and variable, but I'm not sure how I would go about removing the field (that's already inserted into the document). Please advise.
Yours sincerely,
Kevin
if i try to add some data into my table error occurs:
Error:Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'ENG_PREP' can only be specified when a column list is used and IDENTITY_INSERT is ON.
insert into ENG_PREP VALUES('572012-01-1,572012-01-2,572012-01-3,572013-01-1,572013-01-2',
'',
'500',
'',
'A320 P.001-A',
'Removal of the LH Wing Safety Rope',
'',
'',
'',
'0',
'',
'AF',
'12-00-00-081-001',
'',
'',
'',
'',
'',
'',
'' )
how to implement a counter in label which decrements every time page is loaded in asp.net(vb)?
It would be better if that counter value is accessed from and updated into database..
I've tried this on buttonclick but the value is reset automatically to intial value everytime
as the button is insert and page is reloaded
Protected Sub InsertButton_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim entries As Label = FindControl("label1")
entries.Text = entries.Text - 1
End Sub
Hi ,
I am getting the following exception "org.hibernate.HibernateException: The database returned no natively generated identity value "while adding data into database i am using the following code.Please let me know what is wrong
Sesion session=HibernateUtil.getSession();
Transaction tx = session.beginTransaction();
session.save(user);
logger.info("Successfully data insert in database");
tx.commit();
isSaved=true;
Thankx
I find Vim's undo to be a bit too coarse. E.g. if I type something like this:
a // to go into edit mode
to be or not to ve
<esc> // to exit insert mode
Oops! I made a typo. I want to start undoing so I press u, but then it clears the whole line. Is there a way to undo word-by-word or character-by-character?
Maybe this is a stupid question.
In php application I used to insert properly htaccess in home directory that redirect from example.com at www.example.com.
But with django how I have to do ?
I'd like to write some code that runs a sequence of F# scripts (.fsx). The thing is that I could have literally hundreds of scripts and if I do that:
let shellExecute program args =
let startInfo = new ProcessStartInfo()
do startInfo.FileName <- program
do startInfo.Arguments <- args
do startInfo.UseShellExecute <- true
do startInfo.WindowStyle <- ProcessWindowStyle.Hidden
//do printfn "%s" startInfo.Arguments
let proc = Process.Start(startInfo)
()
scripts
|> Seq.iter (shellExecute "fsi")
it could stress too much my 2GB system. Anyway, I'd like to run scripts by batch of n, which seems also a good exercise for learning Async (I guess it's the way to go).
I have written some code and unfortunately it doesn't work:
open System.Diagnostics
let p = shellExecute "fsi" @"C:\Users\Stringer\foo.fsx"
async {
let! exit = Async.AwaitEvent p.Exited
do printfn "process has exited"
}
|> Async.StartImmediate
foo.fsx is just a hello world script.
I'd like also to figure out if it's doable to retrieve a return code for each executing script and if not, find another way. Thanks!
It's been ages since I last used Access as a back end but I'm being forced to. I'm using Enterprise Library 4.1, the Data Access Application Block.. with .NET 3.5 and I wanted to know the best way (code sample if possible) to write an insert query that will automatically give me the newly inserted auto-number back..or if it's not possible to do it in one step, how do you recommend doing it?
thanks for your help.
I am using word 2007 and am inserting code into the document. I have a style with a fixed-width font and light grey background and all, and I use Notepad++ for syntax highlighting.
My problem is with a "line" of code that is too long to display, so is there a way to auto-insert an arrow symbol at the beginning of a such lines to indicate that it is the same line (kind of like hyphenating, except on long lines instead of long words)
So for e.g. something like this:
public static void foo(String abcdefg, Boolean 123,
?String xyz)
Besides doing it manually using regular expression search, is there other better ways to parse a JAD file?
I need to be able to search for and replace/insert a new MIdlet-Install-Notify property to a JAD file given, also updating the value of the MIDlet-Jar-URL property.
Using ANTLR or TinyPG is a bit overkill for my case.
TIA
Hello,
As the title said, I have a CAF file and I want to insert that file into a video file using ffmpeg(Programmatically ) using C.
CAF file has Linear PCM audio format
I am successfully able to build the video file and now want to add the audio to the video file from CAF (Core Audio Format) file.
Can anyone provide a sample please.
Thanks
Hi,
While working with DB, I find useful using some tools, that help me to solve DB problems.
Some of them are:
1) Insert generator
2) A tool that can execute a script on a list of DB's
3) Finding a text in stored procedures and functions.
4) DB Back up scripts
My question is, what are most useful tools, scripts(anything else), that help you to work with MS SQL?
Thanks in advance.
I need to call Atan on millions of values per second. Is there a good library to perform this operation in batch very fast. For example, a library that streams the low level logic using something like SSE?
I know that there is support for this in OpenCL, but I would prefer to do this operation on the CPU. The target machine might not support OpenCL.
I also looked into using OpenCV, but it's accuracy for Atan angles is only ~0.3 degrees. I need accurate results.
I have a bunch of records with dates formatted as a string such as '04/17/2009'
I want to convert them to a mysql datetime field
I plan to use a foreach loop to read the old date value and insert the newly formatted value into a new field in each record
what would be the best way to convert that string...I thought php might have a way to do it automatically?
thanks
Hello all. I am following the the tutorial at http://www.py2exe.org/index.cgi/Tutorial to figure out how to use py2exe. I get down to step 3 where you are suppose to run the command:
python setup.py py2exe
I do that and then I get this error:
'python' is not recognized as an internal or external command,
operable program or batch file.
I have python 2.4 installed on my machine. any idea's? I am sure it is something simple.
I have a database on line with Godaddy (who uses SQL Server 2005). They provide basic management tools, but tell you that for more advanced tools you can connect directly using SSMS. I followed their instructions to ensure my online database will accept remote connections, and can apparently log in using SSMS with success (after giving my hostname and access data).
However: When attempting to expand the "Databases" folder tree, I get the following error:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server& LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The server principal "cmitchell" is not able to access the database "3pointdb" under the current security context. (Microsoft SQL Server, Error: 916)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4262&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476
Hello,
I'm using ADO.NET entity framework, and am using an AdventureWorks database attached to my local database server. For unit testing, what approaches have people taken to work with a database?
Obviously, the database has to be in a pre-defined state of change so that the tests can have some isolation from each other... so I need to be able to run through the inserts and updates, then rollback either between tests or after the batch of tests are done.
Any advice?
Thanks.
I want to combine these two queries into one:
mysql_query("INSERT INTO categories (name, parent) VALUES ('$name', '$parent')");
mysql_query("UPDATE categories SET child='$child' WHERE ID = $id");
Can it be done?
I have a list of tuples.
[
"Bob": 3,
"Alice: 2,
"Jane": 1,
]
When incrementing the counts
"Alice" += 2
the order should be maintained:
[
"Alice: 4,
"Bob": 3,
"Jane": 1,
]
When all is in memory there rather simple ways (some more or some less) to efficiently implement this. (using an index, insert-sort etc) The question though is: What's the most promising approach when the list does not fit into memory.
Bonus question: What if not even the index fits into memory?
How would you approach this?
I am working with the Parallel libraries in .net 4 and I am creating a Partitioner and the example shown in the MSDN only has a chunk size of 1 (every time a new result is retrieved it hits the data source instead of the local cache. The version I am writing will pull 10000 SQL rows at a time then feed the rows from the cache until it is empty then pull another batch.
Each partition in the Partitioner has its own chunk. I know every time I call to the IEnumerator in from the SQL data-source that needs to be thread safe but for use in a Parallel.ForEach do I need to make every call to the cache for the chunking thread safe?
Hello
I have a mysql database table to store country name and currency symbol - the CHARSET has correctly set to UTF8.
This is example data inserted into the table
insert into country ( country_name, currency_name, currency_code, currency_symbol) values
('UK','Pounds','GBP','£');
When I look in the database - the pound symbol appears fine - but when I retrieve it from the database and display it on the website - a weird square symbol shows up with a question mark inside instead of the pound symbol.
You can look at it here - http://www.didyouswipe.com/profile/view-profile/user_id/181
Please advice
Thanks
Hello
I installed Eclipse and Android ADT. When I create android project and try to run, I get following on main.out.xml file:
This document is empty.
Right click here to insert content
However, main.xml file has xml data for layout.
Please help what I need to do after right clicking. Thanks
User writes a series of tags (, separated) and posts the form.
I build an array containing the tags and delete dupes with array_unique() php function.
I'm thinking of doing:
go through the array with foreach($newarray as $item) { ... }
check each $item for existence in the tags mySQL table
if item does not exists, insert into tags table
Is there a FASTER or MORE OPTIMUM way for doing this?
Everything possible with the OleDBDataReader class.
ExecuteReader() for SELECT statements, and ExecuteNonQuery() for DELETE, UPDATE and INSERT statements.
So why is OleDbDataAdapter class needed?