This can be done in Firebird:
execute block returns(id_out integer,wo varchar(6),parent integer)
as
declare variable n integer;
declare variable i integer;
declare variable wo_old varchar(6);
begin
select count(*) from table1 into :n;
select id,name,id as parent from table1 order by id rows 1...
You must have Windows 2003 Server operation system (or other server system operation) to install SQL Server 2000. If you need to learn SQL language only, you can use SQL Server 2005 Express Edition which can be installed on XP.
cbrn,
Maybe I was out of luck with laptops. Used just for demos on customer site. I prefer to build my own rig and maximise it's performance. And don't forget he wants to use Solidworks also. No chance with a laptop. I still consider the laptop a fancy toy for a serious engineer.
"If you can predict the values then you are aware of the phenomenom" said by JJ Thompson (not sure, maybe my memory let me down :)) Important is the concept.
You can have small deformations (which obbey the Hook's law) but large rotations. This is a non-linear analysis. See "Foundations of non-linear elasticity" by VV Novozhilov
It's nice to see that engineering community retains it's sense of humour :) Now, seriously, I see a CAE engineer like that:
-design the product in Soliworks or Unigraphics (for example)
-import the model and do an analysis with Ansys or Abaqus (for example)
-conduct an experiment to verify his...
A laptop is a joke for a serious stress analyst. It's maded for bussines people to impress the stupid ones (which represents the majority). Talk with a good IT engineer and you'll get the right answer.
I believe you have a large strain problem where your elements submit large deformations. Redo the mesh accordingly with the state problem or try to do a rezoning to keep area elements at a reasonable shape.
if you use rigid body elements how can you expect to have stresses ?? Your problem is to impose constraints in a such manner to avoid rigid body DISPLACEMENTS! Check again your case.
The question is : does CFDesign knows how to use multiprocessor chips? You must ask CFDesign team to answer to this question. Simply put, if CFDesign is not "programmed" to get advantages from dual or quad cores then nothing will important will happend.
From the 64 bit point of vue, yes, the...
select t.f1,t.f2,f22, (select count(*) from tbl2 where f11=t.f1) as tuples from tbl1 t, tbl2 where f1=f11
f1 is field1 from tabl1
f2 is field2 from tabl1
f11 is field1 from tabl2
f22 is field2 from tabl2
I'll create a trigger on the BeforeUpdate event of the updating table. Here you have access to the OLD values as well for the NEW ones. So, let's say, having a History table the sql in the trigger should be like:
insert into history (a,b,c...) values (old.a,old.b,old.c ...)
You can insert the...
Remove ID from the group clause else you'll obtain the same table. I believe is an ordinary Access base with ID assigned automatically.
Do not forget to assign a UNIQUE clause to the table for FirstName or FirstName and LastName or whatever field(s) you think it will be necessary, to avoid...
